cloudflare/ClickHouse

Public

mirrored fromhttps://github.com/cloudflare/ClickHouse

Watch0 Fork0 Star0

Code Commits Issues Pull requests Actions Insights Security

d8d7c46711b2d765bda8dc6405d59ad08f1aceff

Find a branch or tag

Branches

d8d7c46711b2d765bda8dc6405d59ad08f1aceff

Clone

HTTPS

Download ZIP

ClickHouse/benchmark/monetdb

benchmark/monetdb/log.txt

341lines · modecode

Raw Download

Add new log d056bb8

5 years ago

1	`3`
2	`SELECT count(*) FROM hits;`
3	`1 tuple`
4	`clk: 1.262 ms`
5	`1 tuple`
6	`clk: 1.420 ms`
7	`1 tuple`
8	`clk: 1.190 ms`
9	`3`
10	`SELECT count(*) FROM hits WHERE "AdvEngineID" <> 0;`
11	`1 tuple`
12	`clk: 1.530 sec`
13	`1 tuple`
14	`clk: 1.489 sec`
15	`1 tuple`
16	`clk: 1.490 sec`
17	`3`
18	`SELECT sum("AdvEngineID"), count(*), avg("ResolutionWidth") FROM hits;`
19	`1 tuple`
20	`clk: 597.512 ms`
21	`1 tuple`
22	`clk: 579.383 ms`
23	`1 tuple`
24	`clk: 598.220 ms`
25	`3`
26	`SELECT sum("UserID") FROM hits;`
27	`overflow in calculation.`
28	`clk: 568.003 ms`
29	`overflow in calculation.`
30	`clk: 554.572 ms`
31	`overflow in calculation.`
32	`clk: 552.076 ms`
33	`3`
34	`SELECT COUNT(DISTINCT "UserID") FROM hits;`
35	`1 tuple`
36	`clk: 6.688 sec`
37	`1 tuple`
38	`clk: 6.689 sec`
39	`1 tuple`
40	`clk: 6.652 sec`
41	`3`
42	`SELECT COUNT(DISTINCT "SearchPhrase") FROM hits;`
43	`1 tuple`
44	`clk: 15.702 sec`
45	`1 tuple`
46	`clk: 17.189 sec`
47	`1 tuple`
48	`clk: 15.514 sec`
49	`3`
50	`SELECT min("EventDate"), max("EventDate") FROM hits;`
51	`1 tuple`
52	`clk: 697.770 ms`
53	`1 tuple`
54	`clk: 711.870 ms`
55	`1 tuple`
56	`clk: 697.177 ms`
57	`3`
58	`SELECT "AdvEngineID", count() FROM hits WHERE "AdvEngineID" <> 0 GROUP BY "AdvEngineID" ORDER BY count() DESC;`
59	`18 tuples`
60	`clk: 1.536 sec`
61	`18 tuples`
62	`clk: 1.505 sec`
63	`18 tuples`
64	`clk: 1.492 sec`
65	`3`
66	`SELECT "RegionID", COUNT(DISTINCT "UserID") AS u FROM hits GROUP BY "RegionID" ORDER BY u DESC LIMIT 10;`
67	`10 tuples`
68	`clk: 9.965 sec`
69	`10 tuples`
70	`clk: 10.106 sec`
71	`10 tuples`
72	`clk: 10.136 sec`
73	`3`
74	`SELECT "RegionID", sum("AdvEngineID"), count(*) AS c, avg("ResolutionWidth"), COUNT(DISTINCT "UserID") FROM hits GROUP BY "RegionID" ORDER BY c DESC LIMIT 10;`
75	`10 tuples`
76	`clk: 8.329 sec`
77	`10 tuples`
78	`clk: 8.601 sec`
79	`10 tuples`
80	`clk: 8.039 sec`
81	`3`
82	`SELECT "MobilePhoneModel", COUNT(DISTINCT "UserID") AS u FROM hits WHERE "MobilePhoneModel" <> '' GROUP BY "MobilePhoneModel" ORDER BY u DESC LIMIT 10;`
83	`10 tuples`
84	`clk: 3.385 sec`
85	`10 tuples`
86	`clk: 3.321 sec`
87	`10 tuples`
88	`clk: 3.326 sec`
89	`3`
90	`SELECT "MobilePhone", "MobilePhoneModel", COUNT(DISTINCT "UserID") AS u FROM hits WHERE "MobilePhoneModel" <> '' GROUP BY "MobilePhone", "MobilePhoneModel" ORDER BY u DESC LIMIT 10;`
91	`10 tuples`
92	`clk: 3.510 sec`
93	`10 tuples`
94	`clk: 3.431 sec`
95	`10 tuples`
96	`clk: 3.382 sec`
97	`3`
98	`SELECT "SearchPhrase", count(*) AS c FROM hits WHERE "SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY c DESC LIMIT 10;`
99	`10 tuples`
100	`clk: 10.891 sec`
101	`10 tuples`
102	`clk: 11.483 sec`
103	`10 tuples`
104	`clk: 10.352 sec`
105	`3`
106	`SELECT "SearchPhrase", COUNT(DISTINCT "UserID") AS u FROM hits WHERE "SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY u DESC LIMIT 10;`
107	`10 tuples`
108	`clk: 15.711 sec`
109	`10 tuples`
110	`clk: 15.444 sec`
111	`10 tuples`
112	`clk: 15.503 sec`
113	`3`
114	`SELECT "SearchEngineID", "SearchPhrase", count(*) AS c FROM hits WHERE "SearchPhrase" <> '' GROUP BY "SearchEngineID", "SearchPhrase" ORDER BY c DESC LIMIT 10;`
115	`10 tuples`
116	`clk: 11.433 sec`
117	`10 tuples`
118	`clk: 11.399 sec`
119	`10 tuples`
120	`clk: 11.285 sec`
121	`3`
122	`SELECT "UserID", count() FROM hits GROUP BY "UserID" ORDER BY count() DESC LIMIT 10;`
123	`10 tuples`
124	`clk: 7.184 sec`
125	`10 tuples`
126	`clk: 7.015 sec`
127	`10 tuples`
128	`clk: 6.849 sec`
129	`3`
130	`SELECT "UserID", "SearchPhrase", count() FROM hits GROUP BY "UserID", "SearchPhrase" ORDER BY count() DESC LIMIT 10;`
131	`10 tuples`
132	`clk: 29.096 sec`
133	`10 tuples`
134	`clk: 28.328 sec`
135	`10 tuples`
136	`clk: 29.247 sec`
137	`3`
138	`SELECT "UserID", "SearchPhrase", count(*) FROM hits GROUP BY "UserID", "SearchPhrase" LIMIT 10;`
139	`10 tuples`
140	`clk: 29.457 sec`
141	`10 tuples`
142	`clk: 29.364 sec`
143	`10 tuples`
144	`clk: 29.269 sec`
145	`3`
146	`SELECT "UserID", extract(minute FROM "EventTime") AS m, "SearchPhrase", count() FROM hits GROUP BY "UserID", m, "SearchPhrase" ORDER BY count() DESC LIMIT 10;`
147	`10 tuples`
148	`clk: 47.141 sec`
149	`10 tuples`
150	`clk: 46.495 sec`
151	`10 tuples`
152	`clk: 46.472 sec`
153	`3`
154	`SELECT "UserID" FROM hits WHERE "UserID" = -6101065172474983726;`
155	`0 tuples`
156	`clk: 783.332 ms`
157	`0 tuples`
158	`clk: 771.157 ms`
159	`0 tuples`
160	`clk: 783.082 ms`
161	`3`
162	`SELECT count(*) FROM hits WHERE "URL" LIKE '%metrika%';`
163	`1 tuple`
164	`clk: 3.963 sec`
165	`1 tuple`
166	`clk: 3.930 sec`
167	`1 tuple`
168	`clk: 3.964 sec`
169	`3`
170	`SELECT "SearchPhrase", min("URL"), count(*) AS c FROM hits WHERE "URL" LIKE '%metrika%' AND "SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY c DESC LIMIT 10;`
171	`10 tuples`
172	`clk: 3.925 sec`
173	`10 tuples`
174	`clk: 3.817 sec`
175	`10 tuples`
176	`clk: 3.802 sec`
177	`3`
178	`SELECT "SearchPhrase", min("URL"), min("Title"), count(*) AS c, COUNT(DISTINCT "UserID") FROM hits WHERE "Title" LIKE '%Яндекс%' AND "URL" NOT LIKE '%.yandex.%' AND "SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY c DESC LIMIT 10;`
179	`10 tuples`
180	`clk: 6.067 sec`
181	`10 tuples`
182	`clk: 6.120 sec`
183	`10 tuples`
184	`clk: 6.012 sec`
185	`3`
186	`SELECT * FROM hits WHERE "URL" LIKE '%metrika%' ORDER BY "EventTime" LIMIT 10;`
187	`10 tuples !87 columns dropped, 29 fields truncated!`
188	`clk: 4.251 sec`
189	`10 tuples !87 columns dropped, 29 fields truncated!`
190	`clk: 4.190 sec`
191	`10 tuples !87 columns dropped, 29 fields truncated!`
192	`clk: 4.379 sec`
193	`3`
194	`SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY "EventTime" LIMIT 10;`
195	`10 tuples`
196	`clk: 6.699 sec`
197	`10 tuples`
198	`clk: 6.718 sec`
199	`10 tuples`
200	`clk: 6.802 sec`
201	`3`
202	`SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY "SearchPhrase" LIMIT 10;`
203	`10 tuples`
204	`clk: 6.887 sec`
205	`10 tuples`
206	`clk: 6.838 sec`
207	`10 tuples`
208	`clk: 6.844 sec`
209	`3`
210	`SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY "EventTime", "SearchPhrase" LIMIT 10;`
211	`10 tuples`
212	`clk: 6.806 sec`
213	`10 tuples`
214	`clk: 6.878 sec`
215	`10 tuples`
216	`clk: 6.807 sec`
217	`3`
218	`SELECT "CounterID", avg(length("URL")) AS l, count() AS c FROM hits WHERE "URL" <> '' GROUP BY "CounterID" HAVING count() > 100000 ORDER BY l DESC LIMIT 25;`
219	`25 tuples`
220	`clk: 1:01 min`
221	`25 tuples`
222	`clk: 55.553 sec`
223	`25 tuples`
224	`clk: 56.188 sec`
225	`3`
226	`SELECT sys.getdomain("Referer") AS key, avg(length("Referer")) AS l, count() AS c, min("Referer") FROM hits WHERE "Referer" <> '' GROUP BY key HAVING count() > 100000 ORDER BY l DESC LIMIT 25;`
227	`clk: 1:00 min`
228	`clk: 1:00 min`
229	`clk: 1:00 min`
230	`3`
231	SELECT sum("ResolutionWidth"), sum("ResolutionWidth" + 1), sum("ResolutionWidth" + 2), sum("ResolutionWidth" + 3), sum("ResolutionWidth" + 4), sum("ResolutionWidth" + 5), sum("ResolutionWidth" + 6), sum("ResolutionWidth" + 7), sum("ResolutionWidth" + 8), sum("ResolutionWidth" + 9), sum("ResolutionWidth" + 10), sum("ResolutionWidth" + 11), sum("ResolutionWidth" + 12), sum("ResolutionWidth" + 13), sum("ResolutionWidth" + 14), sum("ResolutionWidth" + 15), sum("ResolutionWidth" + 16), sum("ResolutionWidth" + 17), sum("ResolutionWidth" + 18), sum("ResolutionWidth" + 19), sum("ResolutionWidth" + 20), sum("ResolutionWidth" + 21), sum("ResolutionWidth" + 22), sum("ResolutionWidth" + 23), sum("ResolutionWidth" + 24), sum("ResolutionWidth" + 25), sum("ResolutionWidth" + 26), sum("ResolutionWidth" + 27), sum("ResolutionWidth" + 28), sum("ResolutionWidth" + 29), sum("ResolutionWidth" + 30), sum("ResolutionWidth" + 31), sum("ResolutionWidth" + 32), sum("ResolutionWidth" + 33), sum("ResolutionWidth" + 34), sum("ResolutionWidth" + 35), sum("ResolutionWidth" + 36), sum("ResolutionWidth" + 37), sum("ResolutionWidth" + 38), sum("ResolutionWidth" + 39), sum("ResolutionWidth" + 40), sum("ResolutionWidth" + 41), sum("ResolutionWidth" + 42), sum("ResolutionWidth" + 43), sum("ResolutionWidth" + 44), sum("ResolutionWidth" + 45), sum("ResolutionWidth" + 46), sum("ResolutionWidth" + 47), sum("ResolutionWidth" + 48), sum("ResolutionWidth" + 49), sum("ResolutionWidth" + 50), sum("ResolutionWidth" + 51), sum("ResolutionWidth" + 52), sum("ResolutionWidth" + 53), sum("ResolutionWidth" + 54), sum("ResolutionWidth" + 55), sum("ResolutionWidth" + 56), sum("ResolutionWidth" + 57), sum("ResolutionWidth" + 58), sum("ResolutionWidth" + 59), sum("ResolutionWidth" + 60), sum("ResolutionWidth" + 61), sum("ResolutionWidth" + 62), sum("ResolutionWidth" + 63), sum("ResolutionWidth" + 64), sum("ResolutionWidth" + 65), sum("ResolutionWidth" + 66), sum("ResolutionWidth" + 67), sum("ResolutionWidth" + 68), sum("ResolutionWidth" + 69), sum("ResolutionWidth" + 70), sum("ResolutionWidth" + 71), sum("ResolutionWidth" + 72), sum("ResolutionWidth" + 73), sum("ResolutionWidth" + 74), sum("ResolutionWidth" + 75), sum("ResolutionWidth" + 76), sum("ResolutionWidth" + 77), sum("ResolutionWidth" + 78), sum("ResolutionWidth" + 79), sum("ResolutionWidth" + 80), sum("ResolutionWidth" + 81), sum("ResolutionWidth" + 82), sum("ResolutionWidth" + 83), sum("ResolutionWidth" + 84), sum("ResolutionWidth" + 85), sum("ResolutionWidth" + 86), sum("ResolutionWidth" + 87), sum("ResolutionWidth" + 88), sum("ResolutionWidth" + 89) FROM hits;
232	`1 tuple !77 columns dropped!`
233	`clk: 6.221 sec`
234	`1 tuple !77 columns dropped!`
235	`clk: 6.170 sec`
236	`1 tuple !77 columns dropped!`
237	`clk: 6.382 sec`
238	`3`
239	`SELECT "SearchEngineID", "ClientIP", count(*) AS c, sum("Refresh"), avg("ResolutionWidth") FROM hits WHERE "SearchPhrase" <> '' GROUP BY "SearchEngineID", "ClientIP" ORDER BY c DESC LIMIT 10;`
240	`10 tuples`
241	`clk: 5.684 sec`
242	`10 tuples`
243	`clk: 5.585 sec`
244	`10 tuples`
245	`clk: 5.463 sec`
246	`3`
247	`SELECT "WatchID", "ClientIP", count(*) AS c, sum("Refresh"), avg("ResolutionWidth") FROM hits WHERE "SearchPhrase" <> '' GROUP BY "WatchID", "ClientIP" ORDER BY c DESC LIMIT 10;`
248	`10 tuples`
249	`clk: 6.281 sec`
250	`10 tuples`
251	`clk: 6.574 sec`
252	`10 tuples`
253	`clk: 6.243 sec`
254	`3`
255	`SELECT "WatchID", "ClientIP", count(*) AS c, sum("Refresh"), avg("ResolutionWidth") FROM hits GROUP BY "WatchID", "ClientIP" ORDER BY c DESC LIMIT 10;`
256	`10 tuples`
257	`clk: 44.641 sec`
258	`10 tuples`
259	`clk: 41.904 sec`
260	`10 tuples`
261	`clk: 43.218 sec`
262	`3`
263	`SELECT "URL", count(*) AS c FROM hits GROUP BY "URL" ORDER BY c DESC LIMIT 10;`
264	`10 tuples`
265	`clk: 1:24 min`
266	`10 tuples`
267	`clk: 1:31 min`
268	`10 tuples`
269	`clk: 1:24 min`
270	`3`
271	`SELECT 1, "URL", count(*) AS c FROM hits GROUP BY 1, "URL" ORDER BY c DESC LIMIT 10;`
272	`10 tuples`
273	`clk: 1:24 min`
274	`10 tuples`
275	`clk: 1:25 min`
276	`10 tuples`
277	`clk: 1:24 min`
278	`3`
279	`SELECT "ClientIP", "ClientIP" - 1, "ClientIP" - 2, "ClientIP" - 3, count(*) AS c FROM hits GROUP BY "ClientIP", "ClientIP" - 1, "ClientIP" - 2, "ClientIP" - 3 ORDER BY c DESC LIMIT 10;`
280	`10 tuples`
281	`clk: 26.438 sec`
282	`10 tuples`
283	`clk: 26.033 sec`
284	`10 tuples`
285	`clk: 26.147 sec`
286	`3`
287	`SELECT "URL", count(*) AS "PageViews" FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "DontCountHits" = 0 AND "Refresh" = 0 AND "URL" <> '' GROUP BY "URL" ORDER BY "PageViews" DESC LIMIT 10;`
288	`10 tuples`
289	`clk: 4.825 sec`
290	`10 tuples`
291	`clk: 4.618 sec`
292	`10 tuples`
293	`clk: 4.623 sec`
294	`3`
295	`SELECT "Title", count(*) AS "PageViews" FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "DontCountHits" = 0 AND "Refresh" = 0 AND "Title" <> '' GROUP BY "Title" ORDER BY "PageViews" DESC LIMIT 10;`
296	`10 tuples`
297	`clk: 4.380 sec`
298	`10 tuples`
299	`clk: 4.418 sec`
300	`10 tuples`
301	`clk: 4.413 sec`
302	`3`
303	`SELECT "URL", count(*) AS "PageViews" FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "Refresh" = 0 AND "IsLink" <> 0 AND "IsDownload" = 0 GROUP BY "URL" ORDER BY "PageViews" DESC LIMIT 1000;`
304	`1000 tuples`
305	`clk: 4.259 sec`
306	`1000 tuples`
307	`clk: 4.195 sec`
308	`1000 tuples`
309	`clk: 4.195 sec`
310	`3`
311	`SELECT "TraficSourceID", "SearchEngineID", "AdvEngineID", CASE WHEN ("SearchEngineID" = 0 AND "AdvEngineID" = 0) THEN "Referer" ELSE '' END AS Src, "URL" AS Dst, count(*) AS "PageViews" FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "Refresh" = 0 GROUP BY "TraficSourceID", "SearchEngineID", "AdvEngineID", CASE WHEN ("SearchEngineID" = 0 AND "AdvEngineID" = 0) THEN "Referer" ELSE '' END, "URL" ORDER BY "PageViews" DESC LIMIT 1000;`
312	`1000 tuples`
313	`clk: 3.233 sec`
314	`1000 tuples`
315	`clk: 3.180 sec`
316	`1000 tuples`
317	`clk: 3.181 sec`
318	`3`
319	`SELECT "URLHash", "EventDate", count(*) AS "PageViews" FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "Refresh" = 0 AND "TraficSourceID" IN (-1, 6) AND "RefererHash" = 686716256552154761 GROUP BY "URLHash", "EventDate" ORDER BY "PageViews" DESC LIMIT 100;`
320	`0 tuples`
321	`clk: 2.656 sec`
322	`0 tuples`
323	`clk: 2.557 sec`
324	`0 tuples`
325	`clk: 2.561 sec`
326	`3`
327	`SELECT "WindowClientWidth", "WindowClientHeight", count(*) AS "PageViews" FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "Refresh" = 0 AND "DontCountHits" = 0 AND "URLHash" = 686716256552154761 GROUP BY "WindowClientWidth", "WindowClientHeight" ORDER BY "PageViews" DESC LIMIT 10000;`
328	`0 tuples`
329	`clk: 4.161 sec`
330	`0 tuples`
331	`clk: 4.243 sec`
332	`0 tuples`
333	`clk: 4.166 sec`
334	`3`
335	`SELECT DATE_TRUNC('minute', "EventTime") AS "Minute", count(*) AS "PageViews" FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-02' AND "Refresh" = 0 AND "DontCountHits" = 0 GROUP BY DATE_TRUNC('minute', "EventTime") ORDER BY DATE_TRUNC('minute', "EventTime");`
336	`0 tuples`
337	`clk: 4.199 sec`
338	`0 tuples`
339	`clk: 4.211 sec`
340	`0 tuples`
341	`clk: 4.190 sec`

cloudflare/ClickHouse

Branches

Tags

Clone