Pinot (c6a.4xlarge, 500gb gp2)†It successfully loaded only 94465149 out of 99997497 records. Some queries returned NullPointerException. The loading process is painful - splitting to 100 pieces required. It does not correctly report errors on data loading, the results may be incorrect.:
Druid (c6a.4xlarge, 500gb gp2)†Druid is killed and restarted after every query. Otherwise some queries make Druid degraded and results are incorrect. For example after Q13 even SELECT 1 works for 7 seconds:
Q1. Query 1: SELECT COUNT(*) FROM hits WHERE AdvEngineID <> 0;
0.04s (×2.25)
0.01s (×1.15)
0.02s (×1.50)
0.03s (×2.00)
0.03s (×1.88)
0.00s (×0.50)
0.03s (×2.00)
0.09s (×5.00)
1.25s (×63.10)
0.32s (×16.70)
1.93s (×96.85)
0.03s (×1.80)
0.03s (×1.99)
0.58s (×29.60)
0.04s (×2.50)
0.01s (×1.10)
0.05s (×3.05)
0.01s (×1.00)
0.24s (×12.50)
0.09s (×4.80)
0.01s (×1.15)
0.35s (×18.00)
0.11s (×5.76)
0.02s (×1.60)
0.19s (×10.00)
0.00s (×0.50)
0.12s (×6.50)
0.41s (×20.85)
0.04s (×2.56)
0.12s (×6.53)
0.31s (×16.05)
0.02s (×1.42)
0.01s (×1.00)
0.12s (×6.58)
0.39s (×19.80)
0.09s (×5.00)
0.05s (×3.02)
0.04s (×2.42)
0.18s (×9.75)
2.25s (×112.90)
1.02s (×51.43)
3.14s (×157.30)
0.46s (×23.50)
0.02s (×1.66)
0.07s (×4.15)
0.10s (×5.55)
0.11s (×6.05)
0.13s (×7.19)
1.67s (×83.85)
1.40s (×70.53)
0.27s (×14.05)
0.04s (×2.50)
5.00s (×250.62)
62.14s (×3107.51)
2.40s (×120.50)
244.58s (×12229.40)
286.96s (×14348.75)
254.24s (×12712.40)
274.52s (×13726.50)
367.55s (×18378.00)
468.47s (×23424.10)
832.87s (×41644.00)
Q2. Query 2: SELECT SUM(AdvEngineID), COUNT(*), AVG(ResolutionWidth) FROM hits;
0.04s (×2.45)
0.02s (×1.40)
0.04s (×2.50)
0.05s (×3.00)
0.04s (×2.31)
0.01s (×1.00)
0.04s (×2.50)
0.11s (×6.00)
0.33s (×16.75)
0.28s (×14.25)
0.22s (×11.60)
0.05s (×2.90)
0.04s (×2.42)
0.47s (×24.25)
0.06s (×3.50)
0.03s (×2.15)
0.04s (×2.65)
0.06s (×3.50)
1.05s (×53.05)
0.04s (×2.65)
0.03s (×2.10)
0.07s (×4.00)
0.12s (×6.56)
0.06s (×3.28)
0.57s (×28.80)
0.09s (×5.00)
0.10s (×5.54)
0.27s (×13.80)
0.11s (×5.94)
0.15s (×8.04)
0.43s (×21.80)
0.03s (×2.25)
0.15s (×8.00)
0.16s (×8.50)
0.56s (×28.50)
0.18s (×9.45)
0.03s (×1.87)
0.05s (×2.93)
0.26s (×13.40)
2.32s (×116.30)
2.42s (×121.60)
3.64s (×182.50)
0.98s (×49.50)
0.05s (×3.21)
0.14s (×7.55)
1.23s (×61.80)
0.37s (×18.95)
2.47s (×124.10)
13.99s (×700.05)
3.59s (×180.17)
0.15s (×8.08)
0.09s (×5.15)
9.86s (×493.71)
67.61s (×3380.95)
0.00s (×0.50)
263.08s (×13154.65)
287.22s (×14361.45)
263.07s (×13154.10)
278.29s (×13915.00)
368.91s (×18446.00)
533.02s (×26651.35)
830.98s (×41549.50)
Q3. Query 3: SELECT AVG(UserID) FROM hits;
0.03s (×1.75)
0.02s (×1.55)
0.06s (×3.50)
0.05s (×3.00)
0.06s (×3.44)
0.01s (×1.00)
0.05s (×3.00)
0.04s (×2.55)
0.18s (×9.55)
0.17s (×8.80)
0.21s (×10.80)
0.07s (×4.15)
0.04s (×2.31)
0.58s (×29.70)
0.06s (×3.50)
0.04s (×2.70)
0.65s (×33.10)
0.08s (×4.50)
0.18s (×9.40)
0.05s (×3.20)
0.04s (×2.70)
0.53s (×26.80)
0.11s (×5.84)
0.18s (×9.36)
0.26s (×13.70)
0.08s (×4.50)
0.15s (×7.91)
0.30s (×15.55)
0.30s (×15.42)
0.13s (×6.77)
0.40s (×20.70)
0.03s (×1.96)
0.08s (×4.50)
0.20s (×10.50)
0.54s (×27.40)
0.24s (×12.75)
0.01s (×1.10)
0.07s (×4.00)
0.24s (×12.40)
2.31s (×116.20)
1.74s (×87.43)
2.51s (×126.20)
0.63s (×31.85)
0.05s (×3.24)
0.20s (×10.67)
0.74s (×37.30)
0.37s (×19.00)
0.51s (×25.86)
6.69s (×335.20)
2.81s (×140.87)
0.13s (×6.95)
0.04s (×2.45)
9.17s (×459.03)
5.90s (×295.60)
6.04s (×302.50)
263.05s (×13152.80)
5.65s (×283.00)
5.06s (×253.50)
21.55s (×1078.00)
377.53s (×18877.00)
638.66s (×31933.70)
830.87s (×41544.00)
Q4. Query 4: SELECT COUNT(DISTINCT UserID) FROM hits;
0.09s (×1.00)
1.77s (×17.99)
0.15s (×1.62)
0.25s (×2.63)
0.11s (×1.20)
0.23s (×2.42)
0.30s (×3.13)
2.01s (×20.44)
0.27s (×2.78)
0.26s (×2.69)
0.37s (×3.87)
1.80s (×18.33)
0.30s (×3.16)
1.99s (×20.20)
1.55s (×15.76)
0.57s (×5.88)
2.03s (×20.58)
0.47s (×4.85)
0.31s (×3.25)
1.89s (×19.17)
1.49s (×15.12)
1.75s (×17.78)
0.32s (×3.28)
0.30s (×3.13)
0.49s (×5.04)
1.32s (×13.43)
0.64s (×6.53)
0.82s (×8.43)
0.58s (×5.98)
1.03s (×10.55)
1.35s (×13.73)
4.51s (×45.67)
1.20s (×12.22)
2.47s (×25.03)
2.51s (×25.41)
1.65s (×16.75)
8.12s (×82.09)
8.15s (×82.46)
3.63s (×36.80)
2.88s (×29.15)
9.72s (×98.28)
2.19s (×22.18)
2.32s (×23.51)
6.16s (×62.36)
33.68s (×340.30)
2.00s (×20.34)
2.27s (×22.99)
☠
4.41s (×44.68)
38.05s (×384.49)
2.52s (×25.51)
☠
38.12s (×385.14)
48.02s (×485.18)
15.69s (×158.59)
330.85s (×3342.04)
48.45s (×489.52)
42.33s (×427.72)
40.81s (×412.32)
384.86s (×3887.58)
714.45s (×7216.72)
842.40s (×8509.19)
Q5. Query 5: SELECT COUNT(DISTINCT SearchPhrase) FROM hits;
0.12s (×1.00)
0.78s (×6.05)
0.28s (×2.23)
0.29s (×2.31)
0.18s (×1.43)
0.25s (×2.00)
0.62s (×4.85)
1.30s (×10.05)
0.30s (×2.37)
0.33s (×2.58)
0.33s (×2.58)
1.03s (×8.04)
0.33s (×2.65)
1.10s (×8.57)
0.89s (×6.92)
0.70s (×5.48)
1.26s (×9.81)
0.90s (×7.00)
0.42s (×3.31)
1.05s (×8.17)
1.09s (×8.45)
1.17s (×9.07)
0.35s (×2.74)
0.45s (×3.57)
0.65s (×5.08)
1.95s (×15.08)
0.56s (×4.41)
1.02s (×7.95)
1.06s (×8.24)
1.21s (×9.36)
1.70s (×13.13)
4.27s (×32.92)
2.63s (×20.31)
1.87s (×14.44)
2.65s (×20.45)
1.46s (×11.31)
9.39s (×72.27)
6.93s (×53.39)
14.69s (×113.05)
2.70s (×20.83)
4.10s (×31.62)
2.74s (×21.17)
4.69s (×36.13)
8.62s (×66.40)
25.77s (×198.29)
3.75s (×28.96)
7.54s (×58.04)
☠
156.14s (×1201.17)
65.64s (×504.98)
6.50s (×50.10)
☠
113.44s (×872.70)
282.44s (×2172.66)
42.37s (×326.00)
356.80s (×2744.70)
344.88s (×2653.03)
356.31s (×2740.96)
467.39s (×3595.38)
574.68s (×4420.69)
826.26s (×6355.92)
869.75s (×6690.46)
Q6. Query 6: SELECT MIN(EventDate), MAX(EventDate) FROM hits;
0.02s (×1.40)
0.01s (×1.25)
0.01s (×1.00)
0.05s (×3.00)
0.03s (×1.94)
0.00s (×0.50)
0.01s (×1.00)
0.02s (×1.55)
0.06s (×3.60)
0.06s (×3.50)
0.05s (×3.05)
0.02s (×1.60)
0.14s (×7.41)
0.02s (×1.55)
0.01s (×1.00)
0.02s (×1.55)
0.02s (×1.70)
0.08s (×4.50)
0.05s (×3.20)
0.02s (×1.50)
0.02s (×1.65)
0.03s (×1.90)
0.10s (×5.74)
0.04s (×2.33)
0.06s (×3.25)
0.00s (×0.50)
0.11s (×5.76)
0.06s (×3.60)
0.08s (×4.61)
0.12s (×6.36)
0.06s (×3.45)
0.06s (×3.66)
0.00s (×0.50)
0.11s (×6.05)
0.05s (×3.00)
0.10s (×5.60)
0.03s (×1.98)
0.03s (×1.88)
☠
2.20s (×110.45)
1.90s (×95.38)
1.98s (×99.70)
0.42s (×21.55)
0.05s (×3.09)
0.09s (×5.00)
0.74s (×37.30)
0.19s (×9.85)
1.07s (×53.80)
6.21s (×310.80)
2.84s (×142.69)
☠
0.09s (×5.15)
7.71s (×385.87)
6.22s (×311.30)
0.00s (×0.50)
262.97s (×13148.90)
10.79s (×540.25)
4.99s (×250.20)
24.20s (×1210.50)
368.23s (×18412.00)
478.06s (×23903.40)
825.54s (×41277.50)
Q7. Query 7: SELECT AdvEngineID, COUNT(*) FROM hits WHERE AdvEngineID <> 0 GROUP BY AdvEngineID ORDER BY COUNT(*) DESC;
0.02s (×1.65)
0.02s (×1.70)
0.02s (×1.50)
0.03s (×2.00)
0.03s (×2.19)
0.01s (×1.00)
0.03s (×2.00)
0.04s (×2.50)
0.19s (×10.20)
0.28s (×14.50)
0.36s (×18.40)
0.03s (×1.85)
0.22s (×11.42)
0.03s (×2.05)
0.04s (×2.50)
0.02s (×1.30)
0.04s (×2.65)
0.02s (×1.50)
0.20s (×10.50)
0.40s (×20.30)
0.01s (×1.20)
0.04s (×2.60)
0.12s (×6.59)
0.02s (×1.69)
0.31s (×15.85)
0.01s (×1.00)
0.13s (×6.95)
0.25s (×13.20)
0.04s (×2.73)
0.12s (×6.38)
0.51s (×25.90)
0.02s (×1.55)
0.02s (×1.50)
0.13s (×6.93)
0.39s (×19.85)
0.10s (×5.55)
0.19s (×9.83)
0.04s (×2.44)
0.13s (×7.20)
3.07s (×154.10)
1.00s (×50.47)
2.40s (×120.65)
0.49s (×25.15)
0.21s (×10.94)
0.07s (×4.24)
0.10s (×5.65)
0.14s (×7.25)
0.07s (×3.90)
1.71s (×85.95)
1.19s (×60.11)
0.27s (×14.19)
0.04s (×2.40)
4.73s (×236.91)
53.53s (×2677.03)
2.42s (×121.50)
263.02s (×13151.30)
286.88s (×14344.45)
263.17s (×13158.75)
275.30s (×13765.50)
384.02s (×19201.50)
474.32s (×23716.40)
829.25s (×41463.00)
Q8. Query 8: SELECT RegionID, COUNT(DISTINCT UserID) AS u FROM hits GROUP BY RegionID ORDER BY u DESC LIMIT 10;
0.14s (×1.03)
0.26s (×1.87)
0.33s (×2.38)
0.31s (×2.24)
0.13s (×1.00)
0.31s (×2.24)
0.51s (×3.63)
0.41s (×2.96)
0.32s (×2.30)
0.31s (×2.26)
0.48s (×3.40)
0.86s (×6.05)
0.68s (×4.83)
0.44s (×3.12)
0.70s (×4.96)
0.96s (×6.76)
0.45s (×3.22)
0.75s (×5.31)
0.37s (×2.63)
0.93s (×6.59)
0.58s (×4.09)
0.57s (×4.07)
0.44s (×3.17)
0.47s (×3.32)
0.59s (×4.21)
1.71s (×12.02)
0.89s (×6.29)
0.95s (×6.72)
0.87s (×6.13)
1.51s (×10.65)
1.63s (×11.47)
4.41s (×30.87)
1.39s (×9.78)
3.74s (×26.23)
2.99s (×20.98)
0.79s (×5.59)
10.98s (×76.81)
8.87s (×62.05)
2.90s (×20.35)
2.48s (×17.38)
7.76s (×54.28)
2.01s (×14.14)
2.89s (×20.24)
9.73s (×68.07)
20.30s (×141.95)
2.03s (×14.25)
3.26s (×22.82)
☠
16.05s (×112.23)
47.01s (×328.59)
10.60s (×74.13)
☠
76.92s (×537.59)
131.10s (×916.20)
22.21s (×155.27)
319.39s (×2231.93)
354.13s (×2474.68)
321.92s (×2249.61)
325.35s (×2273.59)
495.68s (×3463.84)
777.95s (×5436.29)
909.46s (×6355.31)
Q9. Query 9: SELECT RegionID, SUM(AdvEngineID), COUNT(*) AS c, AVG(ResolutionWidth), COUNT(DISTINCT UserID) FROM hits GROUP BY RegionID ORDER BY c DESC LIMIT 10;
0.27s (×1.01)
0.27s (×1.00)
0.34s (×1.27)
0.35s (×1.30)
1.41s (×5.16)
0.85s (×3.12)
0.56s (×2.07)
0.46s (×1.69)
0.41s (×1.53)
0.42s (×1.55)
0.50s (×1.84)
1.08s (×3.93)
1.55s (×5.64)
0.47s (×1.75)
0.76s (×2.79)
0.69s (×2.53)
0.45s (×1.68)
0.86s (×3.15)
0.50s (×1.84)
0.58s (×2.13)
0.65s (×2.39)
0.56s (×2.08)
0.93s (×3.41)
3.53s (×12.83)
0.86s (×3.15)
5.10s (×18.51)
1.09s (×3.97)
1.17s (×4.28)
2.31s (×8.42)
1.42s (×5.17)
1.91s (×6.95)
6.55s (×23.76)
3.48s (×12.64)
5.14s (×18.66)
3.63s (×13.18)
1.02s (×3.74)
14.38s (×52.15)
8.94s (×32.43)
3.21s (×11.67)
2.78s (×10.12)
11.26s (×40.82)
4.43s (×16.10)
5.06s (×18.36)
16.46s (×59.68)
20.47s (×74.20)
4.27s (×15.51)
4.47s (×16.23)
☠
32.35s (×117.25)
51.27s (×185.79)
12.34s (×44.74)
☠
82.47s (×298.85)
136.92s (×496.13)
31.71s (×114.93)
322.22s (×1167.51)
362.26s (×1312.58)
326.17s (×1181.81)
336.95s (×1220.87)
635.96s (×2304.24)
☠
932.32s (×3378.01)
Q10. Query 10: SELECT MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM hits WHERE MobilePhoneModel <> '' GROUP BY MobilePhoneModel ORDER BY u DESC LIMIT 10;
0.06s (×1.00)
0.12s (×1.80)
0.11s (×1.71)
0.13s (×2.00)
0.09s (×1.41)
0.09s (×1.43)
0.11s (×1.71)
0.17s (×2.63)
0.25s (×3.67)
0.24s (×3.59)
0.30s (×4.47)
0.19s (×2.80)
0.66s (×9.61)
0.20s (×3.01)
0.16s (×2.43)
0.29s (×4.26)
0.18s (×2.79)
0.12s (×1.86)
0.29s (×4.33)
0.59s (×8.54)
0.23s (×3.49)
0.21s (×3.11)
0.14s (×2.12)
0.16s (×2.45)
0.37s (×5.43)
0.25s (×3.71)
0.23s (×3.41)
0.46s (×6.66)
0.29s (×4.29)
0.30s (×4.46)
0.59s (×8.53)
0.23s (×3.43)
0.22s (×3.29)
0.50s (×7.33)
0.97s (×13.94)
0.55s (×8.03)
11.66s (×166.76)
1.00s (×14.50)
4.20s (×60.10)
2.05s (×29.39)
1.96s (×28.08)
3.15s (×45.21)
1.71s (×24.59)
9.53s (×136.25)
1.87s (×26.85)
1.40s (×20.17)
2.39s (×34.34)
1.29s (×18.52)
1.77s (×25.46)
4.68s (×67.00)
0.82s (×11.88)
☠
10.08s (×144.16)
56.22s (×803.22)
14.11s (×201.71)
265.38s (×3791.21)
293.89s (×4198.54)
265.68s (×3795.59)
279.87s (×3998.29)
396.49s (×5664.29)
489.22s (×6988.96)
854.74s (×12210.71)
Q11. Query 11: SELECT MobilePhone, MobilePhoneModel, COUNT(DISTINCT UserID) AS u FROM hits WHERE MobilePhoneModel <> '' GROUP BY MobilePhone, MobilePhoneModel ORDER BY u DESC LIMIT 10;
0.06s (×1.00)
0.09s (×1.47)
0.10s (×1.67)
0.16s (×2.58)
0.10s (×1.71)
0.08s (×1.36)
0.14s (×2.27)
0.17s (×2.70)
0.25s (×3.94)
0.23s (×3.71)
0.29s (×4.55)
0.62s (×9.53)
0.33s (×5.08)
0.20s (×3.18)
0.18s (×2.88)
0.31s (×4.80)
0.20s (×3.15)
0.13s (×2.12)
0.34s (×5.29)
0.63s (×9.68)
0.27s (×4.20)
0.24s (×3.77)
0.17s (×2.67)
0.17s (×2.68)
0.37s (×5.74)
0.25s (×3.94)
0.22s (×3.49)
0.49s (×7.65)
0.31s (×4.90)
0.32s (×4.97)
0.63s (×9.71)
0.27s (×4.18)
0.23s (×3.64)
0.56s (×8.57)
1.07s (×16.41)
0.62s (×9.59)
12.27s (×186.05)
1.12s (×17.14)
4.12s (×62.59)
1.97s (×29.98)
1.98s (×30.14)
3.06s (×46.59)
2.16s (×32.82)
9.34s (×141.67)
1.88s (×28.58)
1.42s (×21.67)
2.69s (×40.92)
1.27s (×19.38)
2.21s (×33.67)
5.55s (×84.26)
0.44s (×6.83)
☠
11.19s (×169.66)
55.96s (×847.98)
16.53s (×250.61)
265.46s (×4022.30)
291.73s (×4420.29)
265.34s (×4020.39)
282.00s (×4272.88)
412.55s (×6250.91)
473.71s (×7177.62)
825.14s (×12502.27)
Q12. Query 12: SELECT SearchPhrase, COUNT(*) AS c FROM hits WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
0.14s (×1.00)
0.14s (×1.04)
0.23s (×1.63)
0.16s (×1.16)
0.16s (×1.15)
0.26s (×1.84)
0.54s (×3.74)
0.28s (×1.98)
0.29s (×2.03)
0.33s (×2.29)
0.32s (×2.24)
0.46s (×3.18)
0.34s (×2.41)
0.40s (×2.80)
0.91s (×6.26)
0.76s (×5.20)
0.37s (×2.59)
0.66s (×4.56)
0.37s (×2.59)
0.43s (×3.01)
0.67s (×4.61)
0.53s (×3.66)
0.41s (×2.84)
0.48s (×3.33)
0.57s (×3.92)
1.74s (×11.90)
0.75s (×5.18)
0.89s (×6.11)
1.09s (×7.45)
1.39s (×9.55)
1.40s (×9.62)
3.07s (×20.98)
2.25s (×15.37)
2.05s (×14.01)
2.04s (×13.91)
1.17s (×7.99)
7.78s (×53.00)
0.89s (×6.10)
3.15s (×21.46)
1.94s (×13.23)
2.93s (×19.99)
2.58s (×17.59)
5.13s (×34.98)
9.17s (×62.46)
4.46s (×30.42)
3.61s (×24.63)
6.24s (×42.54)
13.03s (×88.73)
5.20s (×35.45)
11.29s (×76.88)
1.77s (×12.11)
0.29s (×2.07)
15.50s (×105.51)
82.89s (×563.92)
1961.40s (×13342.93)
276.30s (×1879.66)
298.18s (×2028.50)
282.23s (×1920.03)
334.83s (×2277.82)
448.06s (×3048.10)
570.59s (×3881.64)
☠
Q13. Query 13: SELECT SearchPhrase, COUNT(DISTINCT UserID) AS u FROM hits WHERE SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY u DESC LIMIT 10;
0.18s (×1.00)
0.18s (×1.05)
0.75s (×4.09)
0.32s (×1.77)
0.31s (×1.70)
0.43s (×2.37)
0.96s (×5.22)
0.41s (×2.23)
0.39s (×2.16)
0.49s (×2.70)
0.44s (×2.40)
0.59s (×3.20)
0.61s (×3.31)
0.46s (×2.52)
1.36s (×7.37)
1.07s (×5.80)
0.49s (×2.69)
1.48s (×8.01)
0.58s (×3.18)
0.53s (×2.89)
0.96s (×5.21)
0.67s (×3.63)
2.86s (×15.41)
0.92s (×5.02)
0.98s (×5.30)
3.40s (×18.33)
3.43s (×18.50)
1.65s (×8.90)
1.96s (×10.60)
6.56s (×35.34)
2.55s (×13.78)
7.76s (×41.77)
4.62s (×24.89)
9.24s (×49.75)
3.63s (×19.55)
1.68s (×9.07)
25.65s (×137.98)
5.71s (×30.77)
6.37s (×34.32)
3.07s (×16.56)
4.02s (×21.65)
3.08s (×16.64)
6.85s (×36.88)
16.83s (×90.55)
19.69s (×105.94)
4.73s (×25.48)
7.89s (×42.49)
☠
5.19s (×27.94)
14.91s (×80.22)
7.26s (×39.09)
☠
72.52s (×389.93)
96.47s (×518.73)
1167.00s (×6274.25)
279.25s (×1501.40)
301.15s (×1619.14)
279.45s (×1502.50)
307.30s (×1652.20)
813.60s (×4374.25)
691.04s (×3715.31)
860.20s (×4624.78)
Q14. Query 14: SELECT SearchEngineID, SearchPhrase, COUNT(*) AS c FROM hits WHERE SearchPhrase <> '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10;
0.15s (×1.00)
0.16s (×1.03)
0.30s (×1.90)
0.26s (×1.66)
0.18s (×1.18)
0.27s (×1.72)
0.80s (×4.97)
0.33s (×2.08)
0.30s (×1.93)
0.35s (×2.20)
0.32s (×2.01)
0.48s (×3.01)
0.36s (×2.26)
0.41s (×2.55)
0.94s (×5.83)
0.94s (×5.84)
0.39s (×2.48)
0.91s (×5.64)
0.40s (×2.52)
0.44s (×2.79)
0.89s (×5.52)
0.62s (×3.85)
0.48s (×3.02)
0.51s (×3.19)
0.60s (×3.76)
1.60s (×9.88)
0.94s (×5.84)
0.97s (×5.99)
1.12s (×6.95)
1.62s (×9.98)
1.54s (×9.50)
3.29s (×20.26)
2.28s (×14.05)
2.52s (×15.50)
2.16s (×13.31)
1.50s (×9.24)
8.32s (×51.10)
0.95s (×5.87)
3.13s (×19.26)
2.39s (×14.71)
3.06s (×18.86)
3.28s (×20.17)
5.72s (×35.17)
9.87s (×60.61)
5.42s (×33.31)
3.86s (×23.74)
8.23s (×50.58)
11.21s (×68.84)
5.60s (×34.40)
14.62s (×89.73)
59.25s (×363.56)
☠
17.57s (×107.85)
86.28s (×529.39)
2224.14s (×13645.09)
279.67s (×1715.85)
301.02s (×1846.82)
283.61s (×1740.01)
338.52s (×2076.87)
453.98s (×2785.21)
603.75s (×3704.07)
☠
Q15. Query 15: SELECT UserID, COUNT(*) FROM hits GROUP BY UserID ORDER BY COUNT(*) DESC LIMIT 10;
0.12s (×1.03)
0.12s (×1.00)
0.16s (×1.33)
0.26s (×2.11)
0.14s (×1.20)
0.36s (×2.89)
0.34s (×2.73)
0.23s (×1.91)
0.26s (×2.14)
0.30s (×2.44)
0.28s (×2.29)
0.35s (×2.80)
0.32s (×2.61)
0.34s (×2.73)
0.43s (×3.44)
0.76s (×6.05)
0.31s (×2.48)
0.54s (×4.30)
0.39s (×3.11)
0.31s (×2.53)
0.72s (×5.69)
0.46s (×3.64)
0.40s (×3.23)
0.41s (×3.29)
0.53s (×4.24)
1.55s (×12.19)
0.83s (×6.54)
0.87s (×6.91)
0.73s (×5.81)
1.33s (×10.45)
1.51s (×11.87)
3.46s (×27.15)
2.28s (×17.89)
2.55s (×20.03)
2.64s (×20.68)
1.14s (×8.97)
15.47s (×120.95)
1.57s (×12.32)
5.03s (×39.35)
2.21s (×17.34)
7.99s (×62.52)
2.42s (×18.98)
4.02s (×31.51)
15.91s (×124.39)
6.05s (×47.38)
2.63s (×20.62)
5.81s (×45.50)
19.11s (×149.36)
5.46s (×42.70)
26.34s (×205.82)
8.23s (×64.34)
☠
53.57s (×418.63)
42.43s (×331.57)
30.69s (×239.84)
297.66s (×2325.54)
47.00s (×367.27)
32.02s (×250.26)
306.27s (×2392.81)
586.49s (×4582.03)
871.93s (×6812.03)
893.68s (×6981.95)
Q16. Query 16: SELECT UserID, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;
0.32s (×1.02)
0.32s (×1.00)
0.50s (×1.56)
0.45s (×1.41)
0.34s (×1.07)
0.75s (×2.33)
1.20s (×3.71)
0.69s (×2.15)
0.39s (×1.21)
0.46s (×1.44)
0.35s (×1.10)
1.16s (×3.60)
0.39s (×1.24)
0.98s (×3.03)
1.33s (×4.11)
2.71s (×8.34)
0.93s (×2.88)
2.24s (×6.90)
0.64s (×1.99)
0.96s (×2.97)
2.53s (×7.80)
1.43s (×4.42)
0.98s (×3.04)
1.10s (×3.42)
1.00s (×3.10)
4.26s (×13.10)
2.15s (×6.61)
1.78s (×5.49)
2.26s (×6.95)
4.12s (×12.66)
2.99s (×9.20)
9.14s (×28.08)
4.42s (×13.59)
6.99s (×21.46)
5.67s (×17.41)
3.24s (×9.97)
19.69s (×60.44)
☠
5.26s (×16.16)
3.70s (×11.37)
8.92s (×27.38)
2.15s (×6.64)
9.99s (×30.67)
20.77s (×63.73)
15.04s (×46.17)
☠
18.01s (×55.29)
☠
12.75s (×39.13)
36.41s (×111.72)
☠
☠
69.78s (×214.09)
111.81s (×343.00)
16168.44s (×49596.47)
312.57s (×958.83)
342.44s (×1050.47)
304.43s (×933.87)
740.75s (×2272.27)
856.36s (×2626.90)
1026.13s (×3147.68)
☠
Q17. Query 17: SELECT UserID, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, SearchPhrase LIMIT 10;
0.10s (×1.00)
0.24s (×2.28)
0.20s (×1.94)
0.35s (×3.33)
0.39s (×3.66)
0.71s (×6.67)
0.23s (×2.22)
0.48s (×4.55)
0.43s (×4.11)
0.46s (×4.31)
0.99s (×9.29)
0.80s (×7.51)
0.53s (×5.04)
0.61s (×5.75)
0.27s (×2.59)
0.92s (×8.64)
0.63s (×5.95)
0.47s (×4.44)
0.57s (×5.36)
0.68s (×6.43)
1.65s (×15.41)
1.01s (×9.48)
0.99s (×9.27)
1.34s (×12.47)
0.94s (×8.80)
4.01s (×37.22)
1.97s (×18.32)
1.53s (×14.22)
2.40s (×22.35)
3.94s (×36.57)
2.55s (×23.69)
9.42s (×87.31)
4.12s (×38.24)
7.04s (×65.26)
3.88s (×36.01)
2.30s (×21.42)
19.28s (×178.64)
☠
0.83s (×7.77)
2.27s (×21.15)
8.39s (×77.81)
2.82s (×26.22)
7.86s (×72.82)
20.28s (×187.88)
14.59s (×135.22)
☠
17.85s (×165.37)
☠
12.17s (×112.75)
25.90s (×239.90)
☠
3.91s (×36.30)
26.32s (×243.81)
87.79s (×812.96)
120.49s (×1115.74)
302.67s (×2802.61)
305.01s (×2824.23)
287.58s (×2662.85)
734.01s (×6796.48)
848.92s (×7860.46)
974.78s (×9025.87)
☠
Q18. Query 18: SELECT UserID, extract(minute FROM EventTime) AS m, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, m, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;
0.79s (×1.54)
0.74s (×1.46)
1.06s (×2.07)
0.71s (×1.40)
0.66s (×1.31)
0.96s (×1.88)
2.18s (×4.24)
1.63s (×3.18)
0.51s (×1.00)
0.66s (×1.30)
0.56s (×1.10)
2.28s (×4.45)
0.82s (×1.61)
1.72s (×3.34)
2.55s (×4.96)
4.54s (×8.81)
1.55s (×3.03)
4.39s (×8.53)
0.90s (×1.77)
2.31s (×4.51)
4.53s (×8.80)
2.46s (×4.78)
2.03s (×3.95)
1.97s (×3.83)
1.56s (×3.04)
9.56s (×18.55)
4.95s (×9.62)
2.82s (×5.48)
3.47s (×6.74)
7.22s (×14.01)
5.77s (×11.19)
19.61s (×38.03)
☠
☠
9.84s (×19.10)
5.57s (×10.81)
30.21s (×58.56)
☠
☠
2.97s (×5.78)
14.95s (×28.99)
3.58s (×6.96)
16.77s (×32.53)
38.38s (×74.41)
29.66s (×57.50)
☠
32.49s (×62.98)
☠
36.49s (×70.74)
63.51s (×123.10)
☠
☠
121.18s (×234.87)
161.39s (×312.80)
78504.89s (×152141.28)
324.06s (×628.04)
380.38s (×737.20)
327.49s (×634.68)
868.84s (×1683.82)
1011.16s (×1959.63)
1019.72s (×1976.22)
1419.34s (×2750.68)
Q19. Query 19: SELECT UserID FROM hits WHERE UserID = 435090932899640449;
0.01s (×2.17)
0.01s (×2.17)
0.00s (×0.98)
0.01s (×1.97)
0.03s (×3.89)
0.01s (×1.97)
0.00s (×0.98)
0.05s (×5.61)
0.31s (×31.21)
0.16s (×16.34)
0.28s (×28.35)
0.07s (×8.27)
0.03s (×3.45)
0.09s (×9.65)
0.02s (×2.95)
0.02s (×2.66)
0.06s (×6.40)
0.00s (×0.98)
0.16s (×16.74)
0.08s (×9.25)
0.02s (×2.66)
0.04s (×5.02)
0.09s (×9.59)
0.03s (×3.91)
0.18s (×19.10)
0.05s (×5.91)
0.11s (×11.37)
0.26s (×26.19)
0.05s (×6.19)
0.10s (×11.03)
0.42s (×41.94)
0.00s (×1.05)
0.04s (×4.92)
0.10s (×11.31)
0.38s (×37.90)
0.25s (×25.79)
0.03s (×4.41)
0.00s (×1.00)
0.01s (×2.46)
2.38s (×235.69)
0.93s (×92.99)
3.54s (×349.79)
0.57s (×56.71)
0.02s (×3.10)
0.21s (×22.14)
0.11s (×11.72)
0.39s (×39.68)
0.01s (×1.53)
0.00s (×1.18)
0.54s (×53.78)
☠
0.08s (×9.16)
2.13s (×210.42)
2.10s (×207.79)
1.21s (×120.11)
262.70s (×25863.60)
4.91s (×484.67)
2.26s (×223.78)
18.46s (×1818.37)
375.61s (×36979.78)
457.53s (×45044.61)
0.21s (×21.66)
Q20. Query 20: SELECT COUNT(*) FROM hits WHERE URL LIKE '%google%';
0.26s (×3.35)
0.14s (×1.81)
0.60s (×7.63)
0.22s (×2.88)
0.34s (×4.32)
0.20s (×2.63)
1.12s (×14.13)
0.60s (×7.63)
0.28s (×3.63)
0.31s (×4.03)
0.25s (×3.24)
0.83s (×10.50)
0.24s (×3.07)
0.59s (×7.54)
1.22s (×15.38)
1.05s (×13.31)
0.72s (×9.09)
1.05s (×13.25)
0.44s (×5.65)
0.74s (×9.41)
1.04s (×13.14)
0.91s (×11.53)
0.38s (×4.89)
1.52s (×19.07)
0.61s (×7.74)
1.24s (×15.63)
0.74s (×9.36)
0.99s (×12.54)
2.50s (×31.35)
0.82s (×10.32)
1.61s (×20.24)
1.57s (×19.75)
1.74s (×21.88)
1.57s (×19.78)
3.06s (×38.38)
3.67s (×45.98)
2.65s (×33.24)
☠
19.13s (×239.23)
3.17s (×39.80)
3.18s (×39.84)
2.81s (×35.21)
10.36s (×129.64)
6.19s (×77.50)
3.99s (×50.04)
6.07s (×75.99)
15.69s (×196.21)
0.77s (×9.80)
13.32s (×166.64)
7.86s (×98.42)
25.60s (×320.10)
0.07s (×1.00)
27.97s (×349.78)
56.15s (×702.04)
285.83s (×3573.00)
267.47s (×3343.46)
286.57s (×3582.29)
267.50s (×3343.82)
306.66s (×3833.38)
419.90s (×5248.87)
480.25s (×6003.22)
916.92s (×11461.63)
Q21. Query 21: SELECT SearchPhrase, MIN(URL), COUNT(*) AS c FROM hits WHERE URL LIKE '%google%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
0.25s (×2.01)
0.13s (×1.08)
0.34s (×2.69)
0.12s (×1.00)
0.36s (×2.88)
0.14s (×1.15)
0.91s (×7.08)
0.60s (×4.72)
0.25s (×1.98)
0.29s (×2.32)
0.29s (×2.34)
0.86s (×6.73)
0.59s (×4.60)
0.65s (×5.07)
1.09s (×8.46)
0.94s (×7.32)
0.70s (×5.50)
0.94s (×7.31)
0.34s (×2.67)
0.75s (×5.85)
0.95s (×7.36)
1.06s (×8.22)
0.36s (×2.87)
1.58s (×12.24)
0.52s (×4.11)
0.55s (×4.31)
0.79s (×6.16)
0.73s (×5.73)
2.61s (×20.14)
0.89s (×6.93)
1.16s (×9.02)
0.40s (×3.12)
0.98s (×7.62)
1.63s (×12.65)
1.97s (×15.24)
4.18s (×32.27)
2.43s (×18.80)
☠
☠
2.97s (×22.93)
3.52s (×27.14)
2.93s (×22.60)
13.54s (×104.25)
6.89s (×53.06)
4.40s (×33.91)
2.18s (×16.83)
19.20s (×147.75)
0.79s (×6.15)
16.46s (×126.68)
9.02s (×69.44)
☠
☠
29.30s (×225.44)
59.53s (×457.98)
389.23s (×2994.15)
267.47s (×2057.51)
287.18s (×2209.17)
267.69s (×2059.23)
305.12s (×2347.15)
432.88s (×3329.92)
470.04s (×3615.73)
921.70s (×7090.08)
Q22. Query 22: SELECT SearchPhrase, MIN(URL), MIN(Title), COUNT(*) AS c, COUNT(DISTINCT UserID) FROM hits WHERE Title LIKE '%Google%' AND URL NOT LIKE '%.google.%' AND SearchPhrase <> '' GROUP BY SearchPhrase ORDER BY c DESC LIMIT 10;
0.45s (×1.47)
0.32s (×1.07)
0.37s (×1.23)
0.30s (×1.00)
1.03s (×3.36)
0.31s (×1.03)
0.99s (×3.23)
1.71s (×5.54)
0.48s (×1.57)
0.42s (×1.38)
0.48s (×1.57)
1.38s (×4.48)
0.93s (×3.04)
1.07s (×3.50)
1.17s (×3.81)
1.86s (×6.04)
1.27s (×4.12)
2.14s (×6.94)
0.51s (×1.66)
1.19s (×3.85)
1.84s (×5.96)
1.72s (×5.59)
0.61s (×2.00)
3.56s (×11.50)
0.83s (×2.70)
0.89s (×2.90)
1.91s (×6.19)
1.08s (×3.52)
6.77s (×21.88)
1.89s (×6.13)
1.37s (×4.45)
0.40s (×1.31)
1.22s (×3.97)
3.66s (×11.83)
2.47s (×8.00)
7.93s (×25.63)
1.46s (×4.73)
☠
14.23s (×45.93)
2.91s (×9.41)
4.86s (×15.72)
4.05s (×13.09)
36.42s (×117.51)
4.05s (×13.08)
8.69s (×28.06)
26.64s (×85.96)
33.01s (×106.52)
1.70s (×5.51)
25.73s (×83.03)
13.84s (×44.69)
☠
☠
37.70s (×121.64)
57.39s (×185.17)
575.06s (×1855.06)
263.10s (×848.73)
288.64s (×931.12)
263.12s (×848.81)
298.44s (×962.74)
420.73s (×1357.23)
470.19s (×1516.79)
918.37s (×2962.52)
Q23. Query 23: SELECT * FROM hits WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 10;
0.72s (×12.83)
0.74s (×13.23)
0.25s (×4.58)
0.26s (×4.76)
1.35s (×24.04)
0.39s (×7.05)
0.46s (×8.28)
2.11s (×37.35)
0.49s (×8.84)
0.70s (×12.44)
0.42s (×7.66)
3.08s (×54.49)
0.91s (×16.26)
3.32s (×58.60)
2.69s (×47.57)
3.69s (×65.26)
2.81s (×49.61)
2.65s (×46.86)
0.96s (×17.07)
6.10s (×107.59)
3.60s (×63.65)
3.67s (×64.85)
1.92s (×33.99)
4.89s (×86.25)
2.11s (×37.30)
2.15s (×38.05)
5.96s (×105.20)
2.64s (×46.72)
9.55s (×168.47)
6.81s (×120.17)
4.14s (×73.10)
1.80s (×31.96)
3.35s (×59.20)
13.14s (×231.67)
9.52s (×167.86)
23.07s (×406.64)
0.05s (×1.00)
☠
5.77s (×101.83)
7.60s (×134.02)
20.26s (×357.13)
6.12s (×108.05)
104.73s (×1845.24)
6.24s (×110.06)
55.98s (×986.44)
90.21s (×1589.46)
117.42s (×2068.83)
0.97s (×17.26)
13.37s (×235.64)
81.52s (×1436.43)
6.63s (×116.98)
☠
148.47s (×2615.94)
55.14s (×971.63)
285.64s (×5032.58)
0.34s (×6.08)
287.13s (×5058.77)
267.49s (×4712.77)
309.90s (×5459.99)
545.45s (×9609.90)
425.42s (×7495.23)
1001.20s (×17639.30)
Q24. Query 24: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY EventTime LIMIT 10;
0.05s (×4.49)
0.04s (×4.25)
0.04s (×4.01)
0.05s (×4.82)
0.09s (×8.30)
0.08s (×7.22)
0.04s (×4.01)
0.22s (×18.30)
0.18s (×15.57)
0.20s (×16.77)
0.18s (×15.57)
0.25s (×20.71)
0.07s (×6.08)
0.21s (×17.50)
0.19s (×16.05)
0.27s (×22.39)
0.23s (×19.42)
0.23s (×19.26)
0.24s (×20.15)
0.25s (×20.63)
0.27s (×22.79)
0.28s (×23.28)
0.17s (×14.17)
0.24s (×20.04)
0.43s (×34.99)
0.20s (×16.85)
0.23s (×18.93)
0.47s (×38.28)
0.47s (×38.86)
0.26s (×21.44)
0.64s (×52.25)
0.16s (×13.36)
0.32s (×26.49)
0.48s (×39.62)
1.03s (×83.15)
0.95s (×76.81)
0.00s (×1.00)
0.17s (×14.74)
0.29s (×23.76)
1.95s (×157.39)
1.66s (×134.13)
2.83s (×227.70)
5.31s (×427.15)
2.73s (×220.02)
0.89s (×72.22)
1.76s (×142.30)
4.49s (×361.25)
0.15s (×12.75)
1.03s (×83.15)
3.17s (×254.89)
0.02s (×2.17)
0.26s (×21.51)
10.39s (×834.36)
52.47s (×4212.01)
37.48s (×3008.98)
0.01s (×1.20)
286.87s (×23024.86)
263.14s (×21120.43)
275.00s (×22072.56)
386.37s (×31011.22)
335.70s (×26944.40)
901.80s (×72380.12)
Q25. Query 25: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY SearchPhrase LIMIT 10;
0.04s (×1.00)
0.04s (×1.13)
0.14s (×3.33)
0.05s (×1.33)
0.08s (×1.98)
0.08s (×2.00)
0.14s (×3.33)
0.14s (×3.24)
0.17s (×3.98)
0.18s (×4.27)
0.20s (×4.69)
0.18s (×4.24)
0.07s (×1.68)
0.14s (×3.33)
0.17s (×4.00)
0.23s (×5.44)
0.15s (×3.67)
0.16s (×3.78)
0.24s (×5.53)
0.17s (×4.07)
0.24s (×5.53)
0.18s (×4.33)
0.16s (×3.80)
0.23s (×5.37)
0.30s (×6.80)
0.16s (×3.78)
0.17s (×3.90)
0.38s (×8.71)
0.46s (×10.33)
0.25s (×5.84)
0.51s (×11.53)
0.17s (×3.95)
0.35s (×8.00)
0.37s (×8.44)
0.85s (×19.02)
0.69s (×15.56)
2.06s (×46.04)
0.18s (×4.24)
0.40s (×9.00)
2.72s (×60.62)
1.25s (×28.03)
2.57s (×57.27)
7.21s (×160.38)
2.96s (×65.91)
0.70s (×15.79)
1.75s (×39.09)
3.59s (×79.93)
0.13s (×3.12)
1.29s (×28.84)
2.44s (×54.41)
☠
☠
8.47s (×188.42)
52.40s (×1164.68)
72.07s (×1601.78)
263.09s (×5846.71)
288.59s (×6413.27)
263.10s (×5846.93)
277.46s (×6166.00)
385.05s (×8556.89)
483.23s (×10738.58)
898.30s (×19962.44)
Q26. Query 26: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY EventTime, SearchPhrase LIMIT 10;
0.05s (×1.43)
0.05s (×1.40)
0.04s (×1.25)
0.05s (×1.50)
0.08s (×2.28)
0.07s (×2.00)
0.03s (×1.00)
0.17s (×4.53)
0.19s (×4.90)
0.20s (×5.13)
0.40s (×10.30)
0.23s (×5.88)
0.07s (×1.95)
0.21s (×5.63)
0.19s (×5.00)
0.27s (×6.98)
0.22s (×5.65)
0.16s (×4.25)
0.23s (×6.05)
0.23s (×6.03)
0.51s (×12.93)
0.27s (×7.08)
0.18s (×4.71)
0.24s (×6.32)
0.31s (×8.10)
0.16s (×4.25)
0.23s (×6.11)
0.47s (×12.02)
0.47s (×12.10)
0.29s (×7.50)
0.62s (×15.78)
0.17s (×4.53)
0.32s (×8.25)
0.50s (×12.86)
1.08s (×27.32)
0.95s (×24.13)
2.15s (×54.01)
0.18s (×4.73)
0.50s (×12.72)
2.42s (×60.67)
1.47s (×36.90)
2.92s (×73.37)
9.05s (×226.53)
2.89s (×72.59)
0.89s (×22.44)
1.82s (×45.77)
4.49s (×112.40)
0.14s (×3.75)
1.03s (×26.00)
3.14s (×78.73)
☠
☠
10.41s (×260.44)
51.96s (×1299.20)
40.11s (×1003.00)
0.34s (×8.73)
286.91s (×7173.00)
263.09s (×6577.45)
278.04s (×6951.25)
394.67s (×9867.00)
487.45s (×12186.55)
898.89s (×22472.50)
Q27. Query 27: 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;
0.44s (×3.21)
0.27s (×1.99)
0.54s (×3.93)
0.47s (×3.43)
0.30s (×2.18)
0.13s (×1.00)
1.20s (×8.64)
0.57s (×4.16)
0.40s (×2.91)
0.33s (×2.43)
0.32s (×2.37)
0.76s (×5.51)
0.40s (×2.90)
0.74s (×5.37)
1.27s (×9.14)
0.81s (×5.82)
0.59s (×4.26)
1.45s (×10.43)
0.40s (×2.95)
0.69s (×5.01)
0.77s (×5.54)
0.82s (×5.96)
0.39s (×2.88)
1.25s (×9.03)
0.64s (×4.62)
0.56s (×4.07)
0.90s (×6.47)
1.19s (×8.59)
2.06s (×14.78)
0.85s (×6.17)
1.51s (×10.85)
3.11s (×22.31)
1.15s (×8.29)
1.58s (×11.38)
3.12s (×22.34)
4.32s (×30.94)
10.74s (×76.75)
☠
2.38s (×17.06)
2.52s (×18.08)
6.02s (×43.09)
2.78s (×19.93)
10.65s (×76.18)
9.59s (×68.57)
5.42s (×38.77)
9.59s (×68.57)
15.04s (×107.52)
19.69s (×140.69)
117.06s (×836.20)
13.53s (×96.72)
29.22s (×208.80)
☠
39.69s (×283.56)
59.22s (×423.06)
445.03s (×3178.86)
267.49s (×1910.72)
305.63s (×2183.11)
268.20s (×1915.81)
406.88s (×2906.36)
387.21s (×2765.86)
552.20s (×3944.36)
901.28s (×6437.79)
Q28. Query 28: SELECT REGEXP_REPLACE(Referer, '^https?://(?:www\.)?([^/]+)/.*$', '\1') AS k, AVG(length(Referer)) AS l, COUNT(*) AS c, MIN(Referer) FROM hits WHERE Referer <> '' GROUP BY k HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT 25;
Q30. Query 30: SELECT SearchEngineID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM hits WHERE SearchPhrase <> '' GROUP BY SearchEngineID, ClientIP ORDER BY c DESC LIMIT 10;
0.09s (×1.00)
0.09s (×1.03)
0.23s (×2.38)
0.24s (×2.48)
0.16s (×1.71)
0.17s (×1.78)
0.39s (×3.96)
0.24s (×2.50)
0.37s (×3.80)
0.28s (×2.89)
0.31s (×3.17)
0.44s (×4.42)
0.33s (×3.34)
0.29s (×3.02)
0.49s (×4.95)
0.53s (×5.37)
0.47s (×4.77)
0.50s (×5.05)
0.36s (×3.69)
0.32s (×3.27)
0.48s (×4.85)
0.48s (×4.81)
0.34s (×3.51)
0.40s (×4.11)
0.54s (×5.42)
1.03s (×10.30)
0.66s (×6.61)
0.83s (×8.32)
0.85s (×8.47)
1.07s (×10.66)
1.22s (×12.22)
2.45s (×24.33)
1.11s (×11.09)
2.03s (×20.23)
2.02s (×20.07)
1.26s (×12.59)
19.85s (×196.63)
0.87s (×8.74)
4.57s (×45.30)
2.34s (×23.24)
3.19s (×31.73)
2.95s (×29.34)
7.30s (×72.43)
21.03s (×208.36)
3.61s (×35.86)
2.65s (×26.38)
6.26s (×62.11)
8.47s (×83.95)
2.15s (×21.44)
14.68s (×145.45)
19.24s (×190.57)
☠
20.95s (×207.55)
64.28s (×636.50)
58.07s (×575.05)
274.00s (×2712.92)
295.18s (×2922.68)
270.29s (×2676.28)
331.94s (×3286.63)
489.59s (×4847.52)
578.62s (×5729.01)
859.69s (×8511.88)
Q31. Query 31: SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM hits WHERE SearchPhrase <> '' GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;
0.16s (×1.02)
0.15s (×1.00)
0.20s (×1.27)
0.31s (×1.94)
0.20s (×1.30)
0.29s (×1.82)
0.47s (×2.91)
0.37s (×2.32)
0.29s (×1.79)
0.40s (×2.51)
0.36s (×2.26)
0.54s (×3.36)
0.34s (×2.12)
0.40s (×2.48)
0.54s (×3.33)
0.66s (×4.08)
0.37s (×2.30)
0.71s (×4.36)
0.41s (×2.56)
0.52s (×3.23)
0.65s (×4.01)
1.19s (×7.27)
0.55s (×3.38)
0.59s (×3.62)
0.66s (×4.05)
1.45s (×8.85)
1.11s (×6.82)
1.06s (×6.50)
1.07s (×6.55)
1.63s (×9.97)
1.50s (×9.13)
3.47s (×21.07)
1.70s (×10.36)
3.41s (×20.73)
2.56s (×15.61)
1.68s (×10.25)
43.87s (×265.95)
2.87s (×17.43)
5.01s (×30.41)
3.59s (×21.82)
4.00s (×24.33)
3.16s (×19.20)
8.76s (×53.12)
62.12s (×376.52)
6.91s (×41.95)
3.68s (×22.35)
8.46s (×51.36)
16.06s (×97.37)
2.23s (×13.59)
22.13s (×134.19)
52.45s (×317.95)
☠
25.63s (×155.42)
68.95s (×417.96)
78.92s (×478.36)
281.39s (×1705.45)
298.19s (×1807.27)
275.93s (×1672.33)
500.53s (×3033.58)
647.32s (×3923.21)
609.91s (×3696.47)
921.10s (×5582.48)
Q32. Query 32: SELECT WatchID, ClientIP, COUNT(*) AS c, SUM(IsRefresh), AVG(ResolutionWidth) FROM hits GROUP BY WatchID, ClientIP ORDER BY c DESC LIMIT 10;
0.71s (×1.41)
0.71s (×1.40)
1.53s (×2.99)
1.30s (×2.54)
0.66s (×1.30)
1.04s (×2.04)
2.93s (×5.71)
1.69s (×3.31)
0.51s (×1.00)
0.75s (×1.48)
0.78s (×1.54)
2.06s (×4.03)
0.74s (×1.46)
1.79s (×3.50)
3.49s (×6.80)
4.39s (×8.54)
1.81s (×3.53)
5.13s (×9.98)
1.08s (×2.13)
2.09s (×4.07)
4.31s (×8.40)
2.38s (×4.64)
2.77s (×5.41)
1.69s (×3.29)
1.68s (×3.28)
10.42s (×20.25)
6.49s (×12.63)
3.62s (×7.05)
3.87s (×7.53)
11.25s (×21.87)
5.75s (×11.19)
22.57s (×43.84)
☠
19.81s (×38.49)
9.56s (×18.58)
6.61s (×12.85)
43.52s (×84.52)
☠
5.01s (×9.74)
3.15s (×6.14)
40.11s (×77.90)
4.23s (×8.24)
☠
60.83s (×118.14)
49.09s (×95.33)
☠
33.64s (×65.34)
☠
8.54s (×16.60)
163.35s (×317.21)
☠
☠
129.74s (×251.94)
240.32s (×466.65)
504.96s (×980.52)
426.59s (×828.35)
376.96s (×731.99)
576.93s (×1120.28)
2681.96s (×5207.71)
2792.12s (×5421.61)
2772.84s (×5384.18)
1401.44s (×2721.26)
Q33. Query 33: SELECT URL, COUNT(*) AS c FROM hits GROUP BY URL ORDER BY c DESC LIMIT 10;
0.62s (×1.26)
0.61s (×1.24)
1.67s (×3.33)
1.06s (×2.12)
0.92s (×1.84)
1.41s (×2.82)
4.13s (×8.21)
1.31s (×2.63)
0.60s (×1.21)
0.83s (×1.68)
0.71s (×1.43)
2.01s (×4.00)
0.78s (×1.58)
1.75s (×3.49)
4.87s (×9.68)
3.76s (×7.48)
1.68s (×3.34)
6.82s (×13.55)
1.27s (×2.54)
1.83s (×3.64)
3.69s (×7.34)
2.33s (×4.63)
1.96s (×3.92)
2.82s (×5.62)
2.13s (×4.25)
9.61s (×19.09)
4.53s (×9.01)
3.66s (×7.29)
5.26s (×10.46)
6.42s (×12.76)
6.71s (×13.34)
18.89s (×37.50)
☠
10.16s (×20.18)
9.37s (×18.61)
6.24s (×12.40)
37.64s (×74.70)
☠
5.11s (×10.15)
3.19s (×6.34)
12.89s (×25.59)
3.11s (×6.18)
20.65s (×40.98)
47.26s (×93.79)
21.55s (×42.78)
☠
27.07s (×53.74)
☠
16.86s (×33.48)
91.70s (×181.97)
☠
0.49s (×1.00)
90.16s (×178.91)
460.47s (×913.64)
182468.89s (×362041.47)
418.21s (×829.80)
409.55s (×812.63)
439.78s (×872.60)
831.14s (×1649.11)
954.94s (×1894.74)
834.54s (×1655.85)
1455.55s (×2888.02)
Q34. Query 34: SELECT 1, URL, COUNT(*) AS c FROM hits GROUP BY 1, URL ORDER BY c DESC LIMIT 10;
0.60s (×1.11)
0.65s (×1.19)
1.75s (×3.18)
0.98s (×1.79)
0.94s (×1.71)
1.40s (×2.55)
4.30s (×7.78)
1.32s (×2.40)
0.61s (×1.12)
0.82s (×1.50)
0.54s (×1.00)
1.94s (×3.52)
1.05s (×1.91)
1.48s (×2.69)
4.85s (×8.77)
3.86s (×6.99)
1.53s (×2.78)
6.82s (×12.33)
1.24s (×2.26)
1.78s (×3.23)
3.86s (×6.99)
2.35s (×4.25)
1.91s (×3.46)
2.84s (×5.14)
2.11s (×3.83)
9.84s (×17.78)
4.50s (×8.14)
3.61s (×6.54)
5.16s (×9.34)
6.38s (×11.54)
6.68s (×12.07)
19.05s (×34.40)
☠
10.11s (×18.27)
9.19s (×16.60)
6.30s (×11.39)
38.41s (×69.35)
☠
6.24s (×11.28)
2.69s (×4.88)
13.54s (×24.46)
2.79s (×5.05)
20.85s (×37.65)
46.16s (×83.34)
25.47s (×45.99)
☠
26.81s (×48.42)
☠
16.85s (×30.43)
96.05s (×173.40)
☠
☠
94.48s (×170.56)
471.81s (×851.66)
182468.89s (×329366.25)
422.75s (×763.10)
453.71s (×818.99)
416.70s (×752.19)
830.46s (×1499.04)
953.78s (×1721.64)
838.44s (×1513.44)
1461.83s (×2638.70)
Q35. Query 35: 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;
0.20s (×1.39)
0.20s (×1.41)
0.20s (×1.42)
0.44s (×3.05)
0.14s (×1.00)
0.45s (×3.12)
0.46s (×3.18)
0.41s (×2.85)
0.30s (×2.09)
0.36s (×2.51)
0.34s (×2.36)
0.66s (×4.55)
0.33s (×2.28)
0.64s (×4.43)
1.21s (×8.26)
1.08s (×7.38)
0.60s (×4.13)
2.49s (×16.93)
0.39s (×2.73)
0.66s (×4.55)
1.05s (×7.21)
0.81s (×5.57)
0.64s (×4.39)
0.31s (×2.19)
0.62s (×4.26)
1.79s (×12.19)
1.31s (×8.96)
1.05s (×7.21)
0.65s (×4.45)
1.59s (×10.85)
1.68s (×11.42)
12.98s (×88.02)
1.84s (×12.53)
3.39s (×23.04)
2.69s (×18.26)
1.49s (×10.16)
17.91s (×121.37)
4.01s (×27.26)
5.93s (×40.26)
1.81s (×12.36)
9.90s (×67.13)
1.63s (×11.10)
3.93s (×26.68)
18.68s (×126.62)
7.21s (×48.90)
3.55s (×24.09)
7.47s (×50.70)
44.44s (×301.08)
46.44s (×314.63)
28.03s (×189.96)
60.05s (×406.86)
☠
60.19s (×407.75)
103.47s (×700.93)
66.93s (×453.43)
296.94s (×2011.44)
346.73s (×2348.71)
295.14s (×1999.27)
608.51s (×4121.95)
708.75s (×4800.95)
764.19s (×5176.52)
937.23s (×6348.62)
Q36. Query 36: SELECT URL, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND URL <> '' GROUP BY URL ORDER BY PageViews DESC LIMIT 10;
0.07s (×1.54)
0.06s (×1.46)
0.04s (×1.00)
0.04s (×1.00)
0.30s (×6.22)
0.12s (×2.60)
0.06s (×1.40)
0.12s (×2.50)
0.21s (×4.44)
0.19s (×3.92)
0.22s (×4.62)
0.09s (×2.06)
0.55s (×11.26)
0.11s (×2.42)
0.08s (×1.80)
0.09s (×1.90)
0.07s (×1.58)
0.04s (×1.00)
0.19s (×4.00)
0.09s (×1.98)
0.08s (×1.76)
0.07s (×1.62)
0.28s (×5.71)
0.96s (×19.33)
0.20s (×4.10)
0.14s (×3.00)
0.28s (×5.78)
0.20s (×4.12)
1.88s (×37.81)
0.26s (×5.38)
0.22s (×4.56)
0.32s (×6.64)
0.19s (×4.00)
0.23s (×4.85)
0.25s (×5.18)
3.60s (×72.28)
0.54s (×11.02)
0.04s (×1.01)
0.20s (×4.24)
2.05s (×41.26)
0.17s (×3.59)
1.96s (×39.44)
0.32s (×6.60)
0.80s (×16.18)
1.14s (×22.96)
1.79s (×35.94)
12.62s (×252.50)
0.49s (×10.01)
10.06s (×201.46)
0.54s (×11.02)
1.46s (×29.44)
0.26s (×5.30)
5.87s (×117.60)
3.34s (×67.01)
3.61s (×72.40)
1.48s (×29.82)
0.76s (×15.34)
0.79s (×16.08)
4.13s (×82.80)
3.77s (×75.60)
7.49s (×150.04)
2.77s (×55.60)
Q37. Query 37: SELECT Title, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND DontCountHits = 0 AND IsRefresh = 0 AND Title <> '' GROUP BY Title ORDER BY PageViews DESC LIMIT 10;
0.03s (×1.48)
0.03s (×1.38)
0.03s (×1.35)
0.04s (×1.68)
0.31s (×10.94)
0.09s (×3.37)
0.03s (×1.35)
0.06s (×2.36)
0.14s (×5.02)
0.14s (×4.95)
0.14s (×5.02)
0.05s (×2.02)
0.59s (×20.15)
0.04s (×1.75)
0.03s (×1.35)
0.04s (×1.52)
0.39s (×13.54)
0.03s (×1.35)
0.14s (×5.05)
0.04s (×1.72)
0.03s (×1.48)
0.05s (×2.02)
0.20s (×7.23)
1.10s (×37.51)
0.15s (×5.46)
0.09s (×3.37)
0.16s (×5.69)
0.14s (×5.02)
2.17s (×73.51)
0.20s (×7.10)
0.13s (×4.85)
0.18s (×6.27)
0.08s (×3.03)
0.18s (×6.28)
0.14s (×5.22)
3.61s (×121.92)
0.33s (×11.54)
0.02s (×1.00)
0.07s (×2.66)
1.52s (×51.68)
0.12s (×4.23)
2.15s (×72.90)
0.29s (×10.11)
0.74s (×25.30)
1.15s (×38.97)
0.91s (×30.86)
13.83s (×466.29)
0.18s (×6.48)
7.82s (×263.82)
0.19s (×6.74)
0.91s (×30.90)
0.17s (×6.13)
1.81s (×61.18)
0.83s (×28.37)
0.62s (×21.22)
0.94s (×31.90)
0.59s (×20.11)
0.56s (×19.14)
3.70s (×124.99)
3.27s (×110.50)
1.81s (×61.48)
2.52s (×85.23)
Q38. Query 38: SELECT URL, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND IsRefresh = 0 AND IsLink <> 0 AND IsDownload = 0 GROUP BY URL ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;
0.03s (×2.09)
0.03s (×1.70)
0.02s (×1.46)
0.03s (×1.94)
0.07s (×3.67)
0.11s (×5.83)
0.03s (×1.94)
0.06s (×3.26)
0.15s (×7.83)
0.13s (×6.90)
0.14s (×7.10)
0.05s (×2.77)
0.42s (×21.08)
0.05s (×3.01)
0.02s (×1.46)
0.03s (×1.90)
0.19s (×9.53)
0.02s (×1.46)
0.14s (×7.34)
0.12s (×6.42)
0.03s (×1.94)
0.05s (×2.97)
0.19s (×9.72)
0.11s (×5.70)
0.14s (×7.10)
0.08s (×4.38)
0.14s (×7.30)
0.14s (×7.49)
0.23s (×11.58)
0.16s (×8.10)
0.16s (×8.07)
0.16s (×8.24)
0.05s (×2.92)
0.15s (×7.63)
0.15s (×7.59)
3.74s (×182.38)
0.08s (×4.41)
0.01s (×1.00)
0.03s (×2.14)
1.80s (×88.25)
0.10s (×5.22)
2.48s (×120.93)
0.25s (×12.74)
0.65s (×32.06)
0.96s (×47.00)
0.09s (×4.91)
13.21s (×642.65)
0.05s (×3.14)
9.96s (×484.82)
0.14s (×7.13)
0.29s (×14.46)
0.26s (×12.93)
0.80s (×39.40)
0.31s (×15.40)
0.18s (×9.24)
0.90s (×44.34)
0.24s (×12.06)
0.42s (×20.71)
1.45s (×70.99)
0.96s (×47.16)
1.29s (×63.45)
1.52s (×74.39)
Q39. Query 39: 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 IsRefresh = 0 GROUP BY TraficSourceID, SearchEngineID, AdvEngineID, Src, Dst ORDER BY PageViews DESC LIMIT 10 OFFSET 1000;
0.14s (×2.17)
0.12s (×1.90)
0.06s (×1.00)
0.19s (×2.86)
0.10s (×1.58)
0.22s (×3.29)
0.13s (×2.00)
0.18s (×2.73)
0.30s (×4.37)
0.30s (×4.44)
0.35s (×5.11)
0.12s (×1.86)
0.49s (×7.21)
0.13s (×1.96)
0.14s (×2.14)
0.16s (×2.46)
0.23s (×3.37)
0.14s (×2.14)
0.29s (×4.30)
0.11s (×1.74)
0.18s (×2.76)
0.17s (×2.59)
0.39s (×5.73)
0.15s (×2.27)
0.29s (×4.29)
0.28s (×4.14)
0.43s (×6.35)
0.29s (×4.24)
0.28s (×4.08)
0.45s (×6.58)
0.32s (×4.70)
0.56s (×8.15)
0.36s (×5.29)
0.42s (×6.14)
0.36s (×5.23)
6.26s (×89.61)
0.69s (×9.98)
0.09s (×1.36)
0.65s (×9.44)
2.79s (×40.04)
0.27s (×3.93)
3.58s (×51.34)
0.62s (×9.01)
0.94s (×13.52)
☠
1.13s (×16.33)
22.95s (×328.07)
1.14s (×16.37)
16.06s (×229.63)
1.49s (×21.46)
☠
0.18s (×2.69)
7.71s (×110.28)
4.54s (×65.01)
563.02s (×8043.29)
1.77s (×25.43)
1.52s (×21.86)
1.31s (×18.87)
5.14s (×73.57)
4.68s (×67.00)
8.13s (×116.21)
3.57s (×51.14)
Q40. Query 40: SELECT URLHash, EventDate, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND IsRefresh = 0 AND TraficSourceID IN (-1, 6) AND RefererHash = 3594120000172545465 GROUP BY URLHash, EventDate ORDER BY PageViews DESC LIMIT 10 OFFSET 100;
0.02s (×1.64)
0.02s (×1.59)
0.02s (×1.70)
0.10s (×6.24)
0.05s (×3.22)
0.07s (×4.54)
0.03s (×2.27)
0.04s (×2.61)
0.14s (×8.73)
0.17s (×10.21)
0.13s (×8.05)
0.03s (×2.04)
0.50s (×29.02)
0.04s (×2.89)
0.02s (×1.70)
0.02s (×1.47)
0.29s (×16.84)
0.02s (×1.70)
0.14s (×8.39)
0.15s (×8.96)
0.02s (×1.53)
0.03s (×2.10)
0.14s (×8.42)
0.04s (×3.01)
0.13s (×7.88)
0.02s (×1.70)
0.15s (×8.83)
0.12s (×7.32)
0.08s (×4.95)
0.14s (×8.39)
0.13s (×8.11)
0.10s (×6.39)
0.03s (×2.27)
0.18s (×10.82)
0.13s (×8.11)
0.84s (×47.98)
0.15s (×9.05)
0.01s (×1.00)
0.07s (×4.59)
2.08s (×118.64)
0.11s (×6.54)
2.61s (×148.75)
0.11s (×6.58)
0.67s (×38.53)
0.35s (×20.50)
0.06s (×4.08)
1.52s (×86.88)
0.13s (×8.19)
0.14s (×8.73)
0.14s (×8.41)
0.36s (×20.93)
0.11s (×6.92)
0.64s (×36.78)
0.30s (×17.44)
0.11s (×6.81)
1.97s (×112.00)
0.28s (×16.62)
0.61s (×35.44)
1.41s (×80.53)
0.74s (×42.53)
1.75s (×99.98)
0.94s (×53.87)
Q41. Query 41: SELECT WindowClientWidth, WindowClientHeight, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-01' AND EventDate <= '2013-07-31' AND IsRefresh = 0 AND DontCountHits = 0 AND URLHash = 2868770270353813622 GROUP BY WindowClientWidth, WindowClientHeight ORDER BY PageViews DESC LIMIT 10 OFFSET 10000;
0.02s (×1.62)
0.02s (×1.62)
0.02s (×1.68)
0.11s (×6.72)
0.05s (×3.22)
0.16s (×9.52)
0.02s (×1.68)
0.03s (×2.35)
0.12s (×7.34)
0.17s (×10.30)
0.12s (×7.50)
0.03s (×2.13)
0.23s (×13.54)
0.04s (×2.86)
0.02s (×1.68)
0.01s (×1.23)
0.03s (×2.13)
0.01s (×1.12)
0.15s (×8.96)
0.02s (×1.85)
0.01s (×1.29)
0.02s (×1.90)
0.13s (×7.97)
0.04s (×2.92)
0.13s (×7.73)
0.01s (×1.12)
0.12s (×7.28)
0.14s (×8.23)
0.08s (×4.78)
0.13s (×7.68)
0.12s (×7.28)
0.15s (×9.17)
0.02s (×1.68)
0.12s (×7.35)
0.14s (×8.12)
0.72s (×40.65)
0.07s (×4.59)
0.01s (×1.00)
0.04s (×2.63)
1.95s (×109.53)
0.12s (×7.13)
1.82s (×102.47)
0.10s (×6.10)
0.65s (×36.93)
0.27s (×15.74)
0.06s (×3.98)
1.42s (×79.85)
0.06s (×3.70)
0.13s (×7.90)
0.12s (×7.45)
0.30s (×17.18)
0.12s (×7.06)
0.68s (×38.65)
0.28s (×16.11)
0.08s (×5.04)
1.43s (×80.63)
0.31s (×18.14)
0.54s (×30.52)
1.39s (×78.39)
0.75s (×42.56)
1.98s (×111.15)
0.91s (×51.52)
Q42. Query 42: SELECT DATE_TRUNC('minute', EventTime) AS M, COUNT(*) AS PageViews FROM hits WHERE CounterID = 62 AND EventDate >= '2013-07-14' AND EventDate <= '2013-07-15' AND IsRefresh = 0 AND DontCountHits = 0 GROUP BY DATE_TRUNC('minute', EventTime) ORDER BY DATE_TRUNC('minute', EventTime) LIMIT 10 OFFSET 1000;