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.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.04s (×2.50)
0.03s (×1.99)
0.58s (×29.60)
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.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.07s (×4.00)
0.04s (×2.42)
0.47s (×24.25)
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.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.08s (×4.50)
0.04s (×2.31)
0.58s (×29.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;
1.77s (×14.96)
0.15s (×1.34)
0.25s (×2.18)
0.11s (×1.00)
0.23s (×2.02)
0.30s (×2.60)
2.01s (×17.00)
0.27s (×2.31)
0.26s (×2.23)
0.37s (×3.22)
1.80s (×15.25)
1.56s (×13.19)
0.30s (×2.63)
1.99s (×16.80)
2.03s (×17.11)
0.47s (×4.03)
0.31s (×2.71)
1.89s (×15.95)
1.49s (×12.58)
1.75s (×14.79)
0.32s (×2.73)
0.30s (×2.61)
0.49s (×4.19)
1.32s (×11.17)
0.64s (×5.43)
0.82s (×7.01)
0.58s (×4.98)
1.03s (×8.77)
1.35s (×11.42)
4.51s (×37.98)
1.20s (×10.17)
2.47s (×20.82)
2.51s (×21.14)
1.65s (×13.93)
8.12s (×68.28)
8.15s (×68.58)
3.63s (×30.61)
2.88s (×24.25)
9.72s (×81.74)
2.19s (×18.45)
2.32s (×19.55)
6.16s (×51.87)
33.68s (×283.03)
2.00s (×16.92)
2.27s (×19.12)
☠
4.41s (×37.16)
38.05s (×319.79)
2.52s (×21.21)
☠
38.12s (×320.33)
48.02s (×403.54)
15.69s (×131.90)
330.85s (×2779.63)
48.45s (×407.14)
42.33s (×355.74)
40.81s (×342.94)
384.86s (×3233.36)
714.45s (×6002.26)
842.40s (×7077.23)
Q5. Query 5: SELECT COUNT(DISTINCT SearchPhrase) FROM hits;
0.78s (×4.22)
0.28s (×1.56)
0.29s (×1.61)
0.18s (×1.00)
0.25s (×1.40)
0.62s (×3.39)
1.30s (×7.02)
0.30s (×1.66)
0.33s (×1.80)
0.33s (×1.81)
1.03s (×5.62)
0.88s (×4.78)
0.33s (×1.85)
1.10s (×5.99)
1.26s (×6.85)
0.90s (×4.89)
0.42s (×2.31)
1.05s (×5.71)
1.09s (×5.91)
1.17s (×6.34)
0.35s (×1.92)
0.45s (×2.49)
0.65s (×3.55)
1.95s (×10.53)
0.56s (×3.08)
1.02s (×5.56)
1.06s (×5.76)
1.21s (×6.54)
1.70s (×9.17)
4.27s (×23.00)
2.63s (×14.19)
1.87s (×10.09)
2.65s (×14.29)
1.46s (×7.90)
9.39s (×50.50)
6.93s (×37.31)
14.69s (×78.99)
2.70s (×14.56)
4.10s (×22.10)
2.74s (×14.79)
4.69s (×25.25)
8.62s (×46.39)
25.77s (×138.55)
3.75s (×20.24)
7.54s (×40.55)
☠
156.14s (×839.29)
65.64s (×352.85)
6.50s (×35.01)
☠
113.44s (×609.78)
282.44s (×1518.10)
42.37s (×227.79)
356.80s (×1917.80)
344.88s (×1853.75)
356.31s (×1915.19)
467.39s (×2512.20)
574.68s (×3088.87)
826.26s (×4441.07)
869.75s (×4674.82)
Q6. Query 6: SELECT MIN(EventDate), MAX(EventDate) FROM hits;
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.02s (×1.50)
0.14s (×7.41)
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.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.03s (×2.00)
0.22s (×11.42)
0.03s (×2.05)
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.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.82)
0.68s (×4.83)
0.44s (×3.12)
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.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)
0.77s (×2.83)
1.55s (×5.64)
0.47s (×1.75)
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.12s (×1.28)
0.11s (×1.22)
0.13s (×1.42)
0.09s (×1.00)
0.09s (×1.01)
0.11s (×1.22)
0.17s (×1.86)
0.25s (×2.60)
0.24s (×2.54)
0.30s (×3.17)
0.19s (×1.99)
0.15s (×1.62)
0.66s (×6.81)
0.20s (×2.14)
0.18s (×1.98)
0.12s (×1.32)
0.29s (×3.07)
0.59s (×6.06)
0.23s (×2.47)
0.21s (×2.21)
0.14s (×1.51)
0.16s (×1.74)
0.37s (×3.85)
0.25s (×2.63)
0.23s (×2.42)
0.46s (×4.72)
0.29s (×3.04)
0.30s (×3.16)
0.59s (×6.05)
0.23s (×2.44)
0.22s (×2.33)
0.50s (×5.20)
0.97s (×9.89)
0.55s (×5.69)
11.66s (×118.23)
1.00s (×10.28)
4.20s (×42.61)
2.05s (×20.83)
1.96s (×19.91)
3.15s (×32.06)
1.71s (×17.43)
9.53s (×96.60)
1.87s (×19.04)
1.40s (×14.30)
2.39s (×24.35)
1.29s (×13.13)
1.77s (×18.05)
4.68s (×47.50)
0.82s (×8.42)
☠
10.08s (×102.21)
56.22s (×569.49)
14.11s (×143.02)
265.38s (×2688.01)
293.89s (×2976.82)
265.68s (×2691.11)
279.87s (×2834.83)
396.49s (×4016.04)
489.22s (×4955.25)
854.74s (×8657.54)
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.09s (×1.08)
0.10s (×1.22)
0.16s (×1.89)
0.10s (×1.25)
0.08s (×1.00)
0.14s (×1.67)
0.17s (×1.98)
0.25s (×2.89)
0.23s (×2.72)
0.29s (×3.33)
0.62s (×6.99)
0.18s (×2.11)
0.33s (×3.73)
0.20s (×2.33)
0.20s (×2.31)
0.13s (×1.56)
0.34s (×3.88)
0.63s (×7.10)
0.27s (×3.08)
0.24s (×2.77)
0.17s (×1.96)
0.17s (×1.96)
0.37s (×4.21)
0.25s (×2.89)
0.22s (×2.56)
0.49s (×5.61)
0.31s (×3.59)
0.32s (×3.64)
0.63s (×7.12)
0.27s (×3.07)
0.23s (×2.67)
0.56s (×6.28)
1.07s (×12.03)
0.62s (×7.03)
12.27s (×136.44)
1.12s (×12.57)
4.12s (×45.90)
1.97s (×21.99)
1.98s (×22.10)
3.06s (×34.17)
2.16s (×24.07)
9.34s (×103.89)
1.88s (×20.96)
1.42s (×15.89)
2.69s (×30.01)
1.27s (×14.21)
2.21s (×24.69)
5.55s (×61.79)
0.44s (×5.01)
☠
11.19s (×124.42)
55.96s (×621.85)
16.53s (×183.78)
265.46s (×2949.69)
291.73s (×3241.54)
265.34s (×2948.29)
282.00s (×3133.44)
412.55s (×4584.00)
473.71s (×5263.59)
825.14s (×9168.33)
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.23s (×1.57)
0.16s (×1.11)
0.16s (×1.10)
0.26s (×1.76)
0.54s (×3.59)
0.28s (×1.90)
0.29s (×1.95)
0.33s (×2.20)
0.32s (×2.15)
0.46s (×3.06)
0.63s (×4.18)
0.34s (×2.31)
0.40s (×2.69)
0.37s (×2.48)
0.66s (×4.38)
0.37s (×2.49)
0.43s (×2.89)
0.67s (×4.42)
0.53s (×3.52)
0.41s (×2.73)
0.48s (×3.20)
0.57s (×3.76)
1.74s (×11.44)
0.75s (×4.97)
0.89s (×5.87)
1.09s (×7.16)
1.39s (×9.18)
1.40s (×9.24)
3.07s (×20.16)
2.25s (×14.77)
2.05s (×13.46)
2.04s (×13.37)
1.17s (×7.68)
7.78s (×50.92)
0.89s (×5.86)
3.15s (×20.62)
1.94s (×12.71)
2.93s (×19.20)
2.58s (×16.90)
5.13s (×33.61)
9.17s (×60.02)
4.46s (×29.23)
3.61s (×23.66)
6.24s (×40.87)
13.03s (×85.25)
5.20s (×34.06)
11.29s (×73.86)
1.77s (×11.63)
0.29s (×1.99)
15.50s (×101.37)
82.89s (×541.81)
1961.40s (×12819.67)
276.30s (×1805.95)
298.18s (×1948.95)
282.23s (×1844.73)
334.83s (×2188.50)
448.06s (×2928.56)
570.59s (×3729.42)
☠
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.75s (×3.90)
0.32s (×1.69)
0.31s (×1.62)
0.43s (×2.26)
0.96s (×4.97)
0.41s (×2.13)
0.39s (×2.06)
0.49s (×2.58)
0.44s (×2.29)
0.59s (×3.06)
1.02s (×5.28)
0.61s (×3.16)
0.46s (×2.40)
0.49s (×2.56)
1.48s (×7.64)
0.58s (×3.03)
0.53s (×2.75)
0.96s (×4.97)
0.67s (×3.46)
2.86s (×14.70)
0.92s (×4.79)
0.98s (×5.06)
3.40s (×17.49)
3.43s (×17.65)
1.65s (×8.49)
1.96s (×10.11)
6.56s (×33.70)
2.55s (×13.15)
7.76s (×39.84)
4.62s (×23.74)
9.24s (×47.45)
3.63s (×18.65)
1.68s (×8.65)
25.65s (×131.61)
5.71s (×29.35)
6.37s (×32.74)
3.07s (×15.80)
4.02s (×20.65)
3.08s (×15.87)
6.85s (×35.17)
16.83s (×86.37)
19.69s (×101.05)
4.73s (×24.30)
7.89s (×40.53)
☠
5.19s (×26.65)
14.91s (×76.52)
7.26s (×37.29)
☠
72.52s (×371.93)
96.47s (×494.79)
1167.00s (×5984.67)
279.25s (×1432.11)
301.15s (×1544.41)
279.45s (×1433.15)
307.30s (×1575.95)
813.60s (×4172.36)
691.04s (×3543.83)
860.20s (×4411.33)
Q14. Query 14: SELECT SearchEngineID, SearchPhrase, COUNT(*) AS c FROM hits WHERE SearchPhrase <> '' GROUP BY SearchEngineID, SearchPhrase ORDER BY c DESC LIMIT 10;
0.16s (×1.00)
0.30s (×1.85)
0.26s (×1.61)
0.18s (×1.14)
0.27s (×1.67)
0.80s (×4.82)
0.33s (×2.02)
0.30s (×1.87)
0.35s (×2.14)
0.32s (×1.95)
0.48s (×2.92)
0.91s (×5.48)
0.36s (×2.20)
0.41s (×2.47)
0.39s (×2.40)
0.91s (×5.48)
0.40s (×2.44)
0.44s (×2.70)
0.89s (×5.35)
0.62s (×3.74)
0.48s (×2.93)
0.51s (×3.09)
0.60s (×3.65)
1.60s (×9.58)
0.94s (×5.66)
0.97s (×5.81)
1.12s (×6.74)
1.62s (×9.69)
1.54s (×9.21)
3.29s (×19.65)
2.28s (×13.63)
2.52s (×15.04)
2.16s (×12.91)
1.50s (×8.96)
8.32s (×49.58)
0.95s (×5.70)
3.13s (×18.68)
2.39s (×14.27)
3.06s (×18.30)
3.28s (×19.57)
5.72s (×34.12)
9.87s (×58.80)
5.42s (×32.32)
3.86s (×23.04)
8.23s (×49.08)
11.21s (×66.79)
5.60s (×33.38)
14.62s (×87.06)
59.25s (×352.74)
☠
17.57s (×104.64)
86.28s (×513.63)
2224.14s (×13238.99)
279.67s (×1664.79)
301.02s (×1791.85)
283.61s (×1688.22)
338.52s (×2015.06)
453.98s (×2702.32)
603.75s (×3593.83)
☠
Q15. Query 15: SELECT UserID, COUNT(*) FROM hits GROUP BY UserID ORDER BY COUNT(*) DESC LIMIT 10;
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.42s (×3.36)
0.32s (×2.61)
0.34s (×2.73)
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.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)
1.32s (×4.08)
0.39s (×1.24)
0.98s (×3.03)
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.24s (×1.17)
0.20s (×1.00)
0.35s (×1.71)
0.39s (×1.88)
0.71s (×3.43)
0.23s (×1.14)
0.48s (×2.34)
0.43s (×2.11)
0.46s (×2.21)
0.99s (×4.78)
0.80s (×3.86)
0.32s (×1.57)
0.53s (×2.59)
0.61s (×2.96)
0.63s (×3.06)
0.47s (×2.29)
0.57s (×2.76)
0.68s (×3.30)
1.65s (×7.92)
1.01s (×4.88)
0.99s (×4.77)
1.34s (×6.41)
0.94s (×4.52)
4.01s (×19.14)
1.97s (×9.42)
1.53s (×7.31)
2.40s (×11.49)
3.94s (×18.80)
2.55s (×12.19)
9.42s (×44.90)
4.12s (×19.67)
7.04s (×33.56)
3.88s (×18.52)
2.30s (×11.01)
19.28s (×91.87)
☠
0.83s (×4.00)
2.27s (×10.88)
8.39s (×40.02)
2.82s (×13.49)
7.86s (×37.45)
20.28s (×96.63)
14.59s (×69.54)
☠
17.85s (×85.05)
☠
12.17s (×57.99)
25.90s (×123.38)
☠
3.91s (×18.67)
26.32s (×125.39)
87.79s (×418.09)
120.49s (×573.81)
302.67s (×1441.34)
305.01s (×1452.46)
287.58s (×1369.47)
734.01s (×3495.33)
848.92s (×4042.52)
974.78s (×4641.88)
☠
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.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)
2.53s (×4.92)
0.82s (×1.61)
1.72s (×3.34)
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.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.02s (×2.95)
0.03s (×3.45)
0.09s (×9.65)
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.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)
1.24s (×15.63)
0.24s (×3.07)
0.59s (×7.54)
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.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)
1.14s (×8.85)
0.59s (×4.60)
0.65s (×5.07)
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.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)
1.18s (×3.84)
0.93s (×3.04)
1.07s (×3.50)
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.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)
2.73s (×48.27)
0.91s (×16.26)
3.32s (×58.60)
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.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.19s (×16.05)
0.07s (×6.08)
0.21s (×17.50)
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.14s (×2.94)
0.05s (×1.18)
0.08s (×1.75)
0.08s (×1.76)
0.14s (×2.94)
0.14s (×2.86)
0.17s (×3.51)
0.18s (×3.76)
0.20s (×4.14)
0.18s (×3.75)
0.18s (×3.73)
0.07s (×1.48)
0.14s (×2.94)
0.15s (×3.24)
0.16s (×3.33)
0.24s (×4.88)
0.17s (×3.59)
0.24s (×4.88)
0.18s (×3.82)
0.16s (×3.35)
0.23s (×4.73)
0.30s (×6.00)
0.16s (×3.33)
0.17s (×3.44)
0.38s (×7.69)
0.46s (×9.12)
0.25s (×5.15)
0.51s (×10.18)
0.17s (×3.48)
0.35s (×7.06)
0.37s (×7.44)
0.85s (×16.78)
0.69s (×13.73)
2.06s (×40.62)
0.18s (×3.74)
0.40s (×7.94)
2.72s (×53.49)
1.25s (×24.74)
2.57s (×50.53)
7.21s (×141.51)
2.96s (×58.16)
0.70s (×13.93)
1.75s (×34.49)
3.59s (×70.53)
0.13s (×2.75)
1.29s (×25.45)
2.44s (×48.01)
☠
☠
8.47s (×166.25)
52.40s (×1027.66)
72.07s (×1413.33)
263.09s (×5158.86)
288.59s (×5658.76)
263.10s (×5159.06)
277.46s (×5440.59)
385.05s (×7550.20)
483.23s (×9475.22)
898.30s (×17613.92)
Q26. Query 26: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY EventTime, SearchPhrase LIMIT 10;
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.20s (×5.25)
0.07s (×1.95)
0.21s (×5.63)
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.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)
1.23s (×8.86)
0.40s (×2.90)
0.74s (×5.37)
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.23s (×2.31)
0.24s (×2.40)
0.16s (×1.66)
0.17s (×1.73)
0.39s (×3.85)
0.24s (×2.42)
0.37s (×3.69)
0.28s (×2.81)
0.31s (×3.08)
0.44s (×4.29)
0.51s (×5.00)
0.33s (×3.24)
0.29s (×2.93)
0.47s (×4.63)
0.50s (×4.90)
0.36s (×3.59)
0.32s (×3.17)
0.48s (×4.71)
0.48s (×4.67)
0.34s (×3.41)
0.40s (×3.99)
0.54s (×5.26)
1.03s (×10.00)
0.66s (×6.42)
0.83s (×8.08)
0.85s (×8.23)
1.07s (×10.35)
1.22s (×11.87)
2.45s (×23.63)
1.11s (×10.77)
2.03s (×19.64)
2.02s (×19.49)
1.26s (×12.23)
19.85s (×190.95)
0.87s (×8.49)
4.57s (×43.99)
2.34s (×22.57)
3.19s (×30.81)
2.95s (×28.49)
7.30s (×70.34)
21.03s (×202.35)
3.61s (×34.83)
2.65s (×25.62)
6.26s (×60.32)
8.47s (×81.53)
2.15s (×20.82)
14.68s (×141.25)
19.24s (×185.07)
☠
20.95s (×201.56)
64.28s (×618.14)
58.07s (×558.46)
274.00s (×2634.66)
295.18s (×2838.38)
270.29s (×2599.08)
331.94s (×3191.83)
489.59s (×4707.69)
578.62s (×5563.75)
859.69s (×8266.35)
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.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.59s (×3.64)
0.34s (×2.12)
0.40s (×2.48)
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.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)
3.58s (×6.97)
0.74s (×1.46)
1.79s (×3.50)
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.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)
4.56s (×9.07)
0.78s (×1.58)
1.75s (×3.49)
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.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)
4.38s (×7.92)
1.05s (×1.91)
1.48s (×2.69)
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.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)
1.19s (×8.13)
0.33s (×2.28)
0.64s (×4.43)
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.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.05s (×1.20)
0.55s (×11.26)
0.11s (×2.42)
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.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.02s (×1.01)
0.59s (×20.15)
0.04s (×1.75)
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 (×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.02s (×1.46)
0.42s (×21.08)
0.05s (×3.01)
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.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.12s (×1.86)
0.49s (×7.21)
0.13s (×1.96)
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.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.02s (×1.70)
0.50s (×29.02)
0.04s (×2.89)
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.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.02s (×1.68)
0.23s (×13.54)
0.04s (×2.86)
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;