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.01s (×1.00)
0.03s (×2.00)
0.03s (×1.88)
0.00s (×0.50)
0.04s (×2.50)
0.03s (×2.00)
0.09s (×5.00)
0.01s (×1.05)
0.03s (×2.00)
0.04s (×2.50)
0.01s (×1.05)
1.25s (×63.10)
0.32s (×16.70)
0.03s (×1.94)
1.93s (×96.85)
0.03s (×1.80)
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.35s (×18.00)
0.11s (×5.76)
0.02s (×1.60)
0.19s (×10.00)
0.00s (×0.50)
0.05s (×3.20)
0.12s (×6.50)
0.41s (×20.85)
0.04s (×2.56)
0.12s (×6.53)
0.04s (×2.66)
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.18s (×9.75)
2.25s (×112.90)
1.02s (×51.43)
3.14s (×157.30)
0.46s (×23.50)
0.02s (×1.66)
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)
0.40s (×20.40)
2.40s (×120.50)
244.58s (×12229.40)
286.96s (×14348.75)
254.24s (×12712.40)
274.52s (×13726.50)
367.55s (×18378.00)
832.87s (×41644.00)
Q2. Query 2: SELECT SUM(AdvEngineID), COUNT(*), AVG(ResolutionWidth) FROM hits;
0.02s (×1.40)
0.04s (×2.50)
0.01s (×1.25)
0.05s (×3.00)
0.04s (×2.31)
0.01s (×1.00)
0.06s (×3.50)
0.05s (×3.00)
0.11s (×6.00)
0.02s (×1.60)
0.04s (×2.50)
0.03s (×2.00)
0.03s (×1.80)
0.33s (×16.75)
0.28s (×14.25)
0.06s (×3.31)
0.22s (×11.60)
0.05s (×2.90)
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.07s (×4.00)
0.12s (×6.56)
0.06s (×3.28)
0.57s (×28.80)
0.09s (×5.00)
0.10s (×5.37)
0.10s (×5.54)
0.27s (×13.80)
0.11s (×5.94)
0.15s (×8.04)
0.08s (×4.49)
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.26s (×13.40)
2.32s (×116.30)
2.42s (×121.60)
3.64s (×182.50)
0.98s (×49.50)
0.05s (×3.21)
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)
115.78s (×5789.25)
0.00s (×0.50)
263.08s (×13154.65)
287.22s (×14361.45)
263.07s (×13154.10)
278.29s (×13915.00)
368.91s (×18446.00)
830.98s (×41549.50)
Q3. Query 3: SELECT AVG(UserID) FROM hits;
0.02s (×1.55)
0.06s (×3.50)
0.02s (×1.40)
0.05s (×3.00)
0.06s (×3.44)
0.01s (×1.00)
0.06s (×3.50)
0.05s (×3.00)
0.04s (×2.55)
0.03s (×1.95)
0.05s (×3.00)
0.04s (×2.50)
0.03s (×2.20)
0.18s (×9.55)
0.17s (×8.80)
0.05s (×2.75)
0.21s (×10.80)
0.07s (×4.15)
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.53s (×26.80)
0.11s (×5.84)
0.18s (×9.36)
0.26s (×13.70)
0.08s (×4.50)
0.08s (×4.39)
0.15s (×7.91)
0.30s (×15.55)
0.30s (×15.42)
0.13s (×6.77)
0.09s (×5.23)
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.24s (×12.40)
2.31s (×116.20)
1.74s (×87.43)
2.51s (×126.20)
0.63s (×31.85)
0.05s (×3.24)
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)
91.65s (×4582.80)
6.04s (×302.50)
263.05s (×13152.80)
5.65s (×283.00)
5.06s (×253.50)
21.55s (×1078.00)
377.53s (×18877.00)
830.87s (×41544.00)
Q4. Query 4: SELECT COUNT(DISTINCT UserID) FROM hits;
1.77s (×14.96)
0.15s (×1.34)
1.88s (×15.86)
0.25s (×2.18)
0.11s (×1.00)
0.23s (×2.02)
0.28s (×2.44)
0.27s (×2.35)
2.01s (×17.00)
0.34s (×2.98)
1.01s (×8.57)
1.05s (×8.91)
0.32s (×2.76)
0.27s (×2.31)
0.26s (×2.23)
0.75s (×6.43)
0.37s (×3.22)
1.80s (×15.25)
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.75s (×14.79)
0.32s (×2.73)
0.30s (×2.61)
0.49s (×4.19)
1.32s (×11.17)
0.79s (×6.71)
0.64s (×5.43)
0.82s (×7.01)
0.58s (×4.98)
1.03s (×8.77)
0.89s (×7.55)
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)
3.63s (×30.61)
2.88s (×24.25)
9.72s (×81.74)
2.19s (×18.45)
2.32s (×19.55)
6.16s (×51.87)
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)
25.62s (×215.31)
15.69s (×131.90)
330.85s (×2779.63)
48.45s (×407.14)
42.33s (×355.74)
40.81s (×342.94)
384.86s (×3233.36)
842.40s (×7077.23)
Q5. Query 5: SELECT COUNT(DISTINCT SearchPhrase) FROM hits;
0.78s (×4.22)
0.28s (×1.56)
0.85s (×4.64)
0.29s (×1.61)
0.18s (×1.00)
0.25s (×1.40)
0.61s (×3.33)
0.57s (×3.12)
1.30s (×7.02)
0.51s (×2.78)
0.75s (×4.08)
0.76s (×4.14)
0.51s (×2.81)
0.30s (×1.66)
0.33s (×1.80)
0.69s (×3.79)
0.33s (×1.81)
1.03s (×5.62)
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.17s (×6.34)
0.35s (×1.92)
0.45s (×2.49)
0.65s (×3.55)
1.95s (×10.53)
0.89s (×4.85)
0.56s (×3.08)
1.02s (×5.56)
1.06s (×5.76)
1.21s (×6.54)
0.88s (×4.79)
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)
14.69s (×78.99)
2.70s (×14.56)
4.10s (×22.10)
2.74s (×14.79)
4.69s (×25.25)
8.62s (×46.39)
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)
10.20s (×54.90)
42.37s (×227.79)
356.80s (×1917.80)
344.88s (×1853.75)
356.31s (×1915.19)
467.39s (×2512.20)
574.68s (×3088.87)
869.75s (×4674.82)
Q6. Query 6: SELECT MIN(EventDate), MAX(EventDate) FROM hits;
0.01s (×1.92)
0.01s (×1.54)
0.02s (×2.08)
0.05s (×4.62)
0.03s (×2.98)
0.00s (×0.77)
0.01s (×1.54)
0.02s (×2.31)
0.02s (×2.38)
0.02s (×2.38)
0.01s (×1.54)
0.02s (×2.31)
0.02s (×2.31)
0.06s (×5.54)
0.06s (×5.38)
0.05s (×4.54)
0.05s (×4.69)
0.02s (×2.46)
0.14s (×11.40)
0.02s (×2.38)
0.02s (×2.62)
0.08s (×6.92)
0.05s (×4.92)
0.02s (×2.31)
0.03s (×2.92)
0.10s (×8.83)
0.04s (×3.59)
0.06s (×5.00)
0.00s (×0.77)
0.17s (×13.96)
0.11s (×8.87)
0.06s (×5.54)
0.08s (×7.09)
0.12s (×9.79)
0.04s (×3.86)
0.06s (×5.31)
0.06s (×5.63)
0.00s (×0.77)
0.11s (×9.31)
0.05s (×4.62)
0.10s (×8.62)
0.03s (×3.05)
☠
2.20s (×169.92)
1.90s (×146.74)
1.98s (×153.38)
0.42s (×33.15)
0.05s (×4.75)
0.74s (×57.38)
0.19s (×15.15)
1.07s (×82.77)
6.21s (×478.15)
2.84s (×219.52)
☠
0.09s (×7.92)
7.71s (×593.64)
6.22s (×478.92)
0.00s (×1.00)
0.00s (×0.77)
262.97s (×20229.08)
10.79s (×831.15)
4.99s (×384.92)
24.20s (×1862.31)
368.23s (×28326.15)
825.54s (×63503.85)
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.02s (×1.55)
0.03s (×2.00)
0.03s (×2.19)
0.01s (×1.00)
0.02s (×1.50)
0.02s (×1.50)
0.04s (×2.50)
0.01s (×1.25)
0.04s (×2.50)
0.03s (×2.00)
0.01s (×1.25)
0.19s (×10.20)
0.28s (×14.50)
0.03s (×2.17)
0.36s (×18.40)
0.03s (×1.85)
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.04s (×2.60)
0.12s (×6.59)
0.02s (×1.69)
0.31s (×15.85)
0.01s (×1.00)
0.05s (×3.20)
0.13s (×6.95)
0.25s (×13.20)
0.04s (×2.73)
0.12s (×6.38)
0.05s (×2.76)
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.13s (×7.20)
3.07s (×154.10)
1.00s (×50.47)
2.40s (×120.65)
0.49s (×25.15)
0.21s (×10.94)
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)
0.64s (×32.70)
2.42s (×121.50)
263.02s (×13151.30)
286.88s (×14344.45)
263.17s (×13158.75)
275.30s (×13765.50)
384.02s (×19201.50)
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.36s (×2.57)
0.31s (×2.24)
0.13s (×1.00)
0.31s (×2.24)
0.47s (×3.35)
0.45s (×3.21)
0.41s (×2.96)
0.48s (×3.45)
0.55s (×3.91)
0.54s (×3.84)
0.56s (×3.95)
0.32s (×2.30)
0.31s (×2.26)
0.83s (×5.89)
0.48s (×3.40)
0.86s (×6.05)
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.57s (×4.07)
0.44s (×3.17)
0.47s (×3.32)
0.59s (×4.21)
1.71s (×12.02)
0.90s (×6.37)
0.89s (×6.29)
0.95s (×6.72)
0.87s (×6.13)
1.51s (×10.65)
2.26s (×15.85)
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)
2.90s (×20.35)
2.48s (×17.38)
7.76s (×54.28)
2.01s (×14.14)
2.89s (×20.24)
9.73s (×68.07)
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)
377.01s (×2634.60)
22.21s (×155.27)
319.39s (×2231.93)
354.13s (×2474.68)
321.92s (×2249.61)
325.35s (×2273.59)
495.68s (×3463.84)
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.39s (×1.45)
0.35s (×1.30)
1.41s (×5.16)
0.85s (×3.12)
0.55s (×2.03)
0.50s (×1.85)
0.46s (×1.69)
0.54s (×2.00)
0.61s (×2.25)
0.61s (×2.25)
0.61s (×2.25)
0.41s (×1.53)
0.42s (×1.55)
1.15s (×4.20)
0.50s (×1.84)
1.08s (×3.93)
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.56s (×2.08)
0.93s (×3.41)
3.53s (×12.83)
0.86s (×3.15)
5.10s (×18.51)
1.29s (×4.72)
1.09s (×3.97)
1.17s (×4.28)
2.31s (×8.42)
1.42s (×5.17)
2.38s (×8.65)
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)
3.21s (×11.67)
2.78s (×10.12)
11.26s (×40.82)
4.43s (×16.10)
5.06s (×18.36)
16.46s (×59.68)
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)
2617.01s (×9481.96)
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.41)
0.13s (×1.42)
0.09s (×1.00)
0.09s (×1.01)
0.11s (×1.22)
0.11s (×1.22)
0.17s (×1.86)
0.14s (×1.56)
0.09s (×1.01)
0.11s (×1.22)
0.20s (×2.09)
0.25s (×2.60)
0.24s (×2.54)
0.31s (×3.26)
0.30s (×3.17)
0.19s (×1.99)
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.21s (×2.21)
0.14s (×1.51)
0.16s (×1.74)
0.37s (×3.85)
0.25s (×2.63)
0.25s (×2.67)
0.23s (×2.42)
0.46s (×4.72)
0.29s (×3.04)
0.30s (×3.16)
0.35s (×3.67)
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)
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.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)
389.20s (×3942.22)
14.11s (×143.02)
265.38s (×2688.01)
293.89s (×2976.82)
265.68s (×2691.11)
279.87s (×2834.83)
396.49s (×4016.04)
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.13s (×1.50)
0.16s (×1.89)
0.10s (×1.25)
0.08s (×1.00)
0.10s (×1.22)
0.12s (×1.44)
0.17s (×1.98)
0.14s (×1.72)
0.11s (×1.33)
0.13s (×1.56)
0.21s (×2.42)
0.25s (×2.89)
0.23s (×2.72)
0.25s (×2.90)
0.29s (×3.33)
0.62s (×6.99)
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.24s (×2.77)
0.17s (×1.96)
0.17s (×1.96)
0.37s (×4.21)
0.25s (×2.89)
0.30s (×3.40)
0.22s (×2.56)
0.49s (×5.61)
0.31s (×3.59)
0.32s (×3.64)
0.40s (×4.59)
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)
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.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)
384.64s (×4273.87)
16.53s (×183.78)
265.46s (×2949.69)
291.73s (×3241.54)
265.34s (×2948.29)
282.00s (×3133.44)
412.55s (×4584.00)
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.20s (×1.36)
0.16s (×1.11)
0.16s (×1.10)
0.26s (×1.76)
0.55s (×3.66)
0.49s (×3.27)
0.28s (×1.90)
0.54s (×3.61)
0.60s (×3.99)
0.58s (×3.86)
0.49s (×3.30)
0.29s (×1.95)
0.33s (×2.20)
0.58s (×3.85)
0.32s (×2.15)
0.46s (×3.06)
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.53s (×3.52)
0.41s (×2.73)
0.48s (×3.20)
0.57s (×3.76)
1.74s (×11.44)
0.76s (×5.02)
0.75s (×4.97)
0.89s (×5.87)
1.09s (×7.16)
1.39s (×9.18)
1.25s (×8.24)
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)
3.15s (×20.62)
1.94s (×12.71)
2.93s (×19.20)
2.58s (×16.90)
5.13s (×33.61)
9.17s (×60.02)
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)
70.31s (×459.63)
1961.40s (×12819.67)
276.30s (×1805.95)
298.18s (×1948.95)
282.23s (×1844.73)
334.83s (×2188.50)
448.06s (×2928.56)
☠
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.27s (×1.46)
0.32s (×1.69)
0.31s (×1.62)
0.43s (×2.26)
0.92s (×4.77)
0.93s (×4.82)
0.41s (×2.13)
0.76s (×3.95)
0.97s (×5.03)
0.88s (×4.56)
0.79s (×4.08)
0.39s (×2.06)
0.49s (×2.58)
0.99s (×5.11)
0.44s (×2.29)
0.59s (×3.06)
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.67s (×3.46)
2.86s (×14.70)
0.92s (×4.79)
0.98s (×5.06)
3.40s (×17.49)
1.21s (×6.24)
3.43s (×17.65)
1.65s (×8.49)
1.96s (×10.11)
6.56s (×33.70)
1.85s (×9.56)
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)
6.37s (×32.74)
3.07s (×15.80)
4.02s (×20.65)
3.08s (×15.87)
6.85s (×35.17)
16.83s (×86.37)
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)
133.42s (×684.24)
1167.00s (×5984.67)
279.25s (×1432.11)
301.15s (×1544.41)
279.45s (×1433.15)
307.30s (×1575.95)
813.60s (×4172.36)
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.22s (×1.38)
0.26s (×1.61)
0.18s (×1.14)
0.27s (×1.67)
0.74s (×4.46)
0.72s (×4.35)
0.33s (×2.02)
0.58s (×3.51)
0.84s (×5.06)
0.77s (×4.64)
0.63s (×3.80)
0.30s (×1.87)
0.35s (×2.14)
0.62s (×3.77)
0.32s (×1.95)
0.48s (×2.92)
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.62s (×3.74)
0.48s (×2.93)
0.51s (×3.09)
0.60s (×3.65)
1.60s (×9.58)
0.84s (×5.07)
0.94s (×5.66)
0.97s (×5.81)
1.12s (×6.74)
1.62s (×9.69)
1.41s (×8.48)
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)
3.13s (×18.68)
2.39s (×14.27)
3.06s (×18.30)
3.28s (×19.57)
5.72s (×34.12)
9.87s (×58.80)
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)
57.14s (×340.15)
2224.14s (×13238.99)
279.67s (×1664.79)
301.02s (×1791.85)
283.61s (×1688.22)
338.52s (×2015.06)
453.98s (×2702.32)
☠
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.19s (×1.56)
0.26s (×2.11)
0.14s (×1.20)
0.36s (×2.89)
0.32s (×2.58)
0.31s (×2.50)
0.23s (×1.91)
0.64s (×5.05)
0.36s (×2.89)
0.37s (×2.97)
0.50s (×3.97)
0.26s (×2.14)
0.30s (×2.44)
0.79s (×6.23)
0.28s (×2.29)
0.35s (×2.80)
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.46s (×3.64)
0.40s (×3.23)
0.41s (×3.29)
0.53s (×4.24)
1.55s (×12.19)
0.84s (×6.68)
0.83s (×6.54)
0.87s (×6.91)
0.73s (×5.81)
1.33s (×10.45)
1.29s (×10.18)
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)
5.03s (×39.35)
2.21s (×17.34)
7.99s (×62.52)
2.42s (×18.98)
4.02s (×31.51)
15.91s (×124.39)
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)
420.00s (×3281.32)
30.69s (×239.84)
297.66s (×2325.54)
47.00s (×367.27)
32.02s (×250.26)
306.27s (×2392.81)
586.49s (×4582.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.57s (×1.78)
0.45s (×1.41)
0.34s (×1.07)
0.75s (×2.33)
0.98s (×3.04)
1.08s (×3.34)
0.69s (×2.15)
1.83s (×5.63)
1.08s (×3.34)
1.07s (×3.31)
1.81s (×5.57)
0.39s (×1.21)
0.46s (×1.44)
1.60s (×4.94)
0.35s (×1.10)
1.16s (×3.60)
0.39s (×1.24)
0.98s (×3.03)
0.93s (×2.88)
2.24s (×6.90)
0.64s (×1.99)
0.96s (×2.97)
1.43s (×4.42)
0.98s (×3.04)
1.10s (×3.42)
1.00s (×3.10)
4.26s (×13.10)
1.86s (×5.74)
2.15s (×6.61)
1.78s (×5.49)
2.26s (×6.95)
4.12s (×12.66)
4.90s (×15.07)
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)
☠
18.01s (×55.29)
☠
12.75s (×39.13)
36.41s (×111.72)
☠
☠
69.78s (×214.09)
111.81s (×343.00)
266.80s (×818.44)
16168.44s (×49596.47)
312.57s (×958.83)
342.44s (×1050.47)
304.43s (×933.87)
740.75s (×2272.27)
856.36s (×2626.90)
☠
Q17. Query 17: SELECT UserID, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, SearchPhrase LIMIT 10;
0.24s (×1.17)
0.20s (×1.00)
0.37s (×1.79)
0.35s (×1.71)
0.39s (×1.88)
0.71s (×3.43)
0.22s (×1.10)
0.23s (×1.14)
0.48s (×2.34)
1.01s (×4.84)
0.27s (×1.33)
0.26s (×1.29)
1.10s (×5.30)
0.43s (×2.11)
0.46s (×2.21)
1.53s (×7.34)
0.99s (×4.78)
0.80s (×3.86)
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.01s (×4.88)
0.99s (×4.77)
1.34s (×6.41)
0.94s (×4.52)
4.01s (×19.14)
1.81s (×8.69)
1.97s (×9.42)
1.53s (×7.31)
2.40s (×11.49)
3.94s (×18.80)
3.71s (×17.70)
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)
☠
17.85s (×85.05)
☠
12.17s (×57.99)
25.90s (×123.38)
☠
3.91s (×18.67)
26.32s (×125.39)
87.79s (×418.09)
246.48s (×1173.78)
120.49s (×573.81)
302.67s (×1441.34)
305.01s (×1452.46)
287.58s (×1369.47)
734.01s (×3495.33)
848.92s (×4042.52)
☠
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)
1.26s (×2.46)
0.71s (×1.40)
0.66s (×1.31)
0.96s (×1.88)
1.80s (×3.51)
1.98s (×3.86)
1.63s (×3.18)
3.27s (×6.35)
1.86s (×3.62)
2.02s (×3.93)
3.19s (×6.20)
0.51s (×1.00)
0.66s (×1.30)
3.07s (×5.96)
0.56s (×1.10)
2.28s (×4.45)
0.82s (×1.61)
1.72s (×3.34)
1.55s (×3.03)
4.39s (×8.53)
0.90s (×1.77)
2.31s (×4.51)
2.46s (×4.78)
2.03s (×3.95)
1.97s (×3.83)
1.56s (×3.04)
9.56s (×18.55)
3.49s (×6.78)
4.95s (×9.62)
2.82s (×5.48)
3.47s (×6.74)
7.22s (×14.01)
8.64s (×16.76)
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)
☠
32.49s (×62.98)
☠
36.49s (×70.74)
63.51s (×123.10)
☠
☠
121.18s (×234.87)
161.39s (×312.80)
465.40s (×901.96)
78504.89s (×152141.28)
324.06s (×628.04)
380.38s (×737.20)
327.49s (×634.68)
868.84s (×1683.82)
1011.16s (×1959.63)
1419.34s (×2750.68)
Q19. Query 19: SELECT UserID FROM hits WHERE UserID = 435090932899640449;
0.01s (×2.07)
0.00s (×0.94)
0.03s (×3.76)
0.01s (×1.88)
0.03s (×3.71)
0.01s (×1.88)
0.01s (×1.88)
0.01s (×1.88)
0.05s (×5.36)
0.01s (×2.16)
0.02s (×2.82)
0.01s (×1.88)
0.02s (×2.44)
0.31s (×29.78)
0.16s (×15.60)
0.44s (×42.13)
0.28s (×27.06)
0.07s (×7.89)
0.03s (×3.29)
0.09s (×9.21)
0.06s (×6.11)
0.00s (×0.94)
0.16s (×15.97)
0.08s (×8.83)
0.04s (×4.79)
0.09s (×9.15)
0.03s (×3.74)
0.18s (×18.23)
0.05s (×5.64)
0.60s (×57.58)
0.11s (×10.85)
0.26s (×24.99)
0.05s (×5.90)
0.10s (×10.53)
0.02s (×2.89)
0.42s (×40.03)
0.00s (×1.00)
0.04s (×4.70)
0.10s (×10.79)
0.38s (×36.17)
0.25s (×24.62)
0.03s (×4.21)
0.01s (×2.35)
2.38s (×224.94)
0.93s (×88.75)
3.54s (×333.83)
0.57s (×54.12)
0.02s (×2.96)
0.11s (×11.18)
0.39s (×37.87)
0.01s (×1.46)
0.00s (×1.13)
0.54s (×51.33)
☠
0.08s (×8.74)
2.13s (×200.82)
2.10s (×198.31)
0.00s (×1.13)
1.21s (×114.63)
262.70s (×24683.64)
4.91s (×462.56)
2.26s (×213.57)
18.46s (×1735.41)
375.61s (×35292.68)
0.21s (×20.67)
Q20. Query 20: SELECT COUNT(*) FROM hits WHERE URL LIKE '%google%';
0.14s (×1.81)
0.60s (×7.63)
0.26s (×3.38)
0.22s (×2.88)
0.34s (×4.32)
0.20s (×2.63)
1.04s (×13.13)
1.30s (×16.38)
0.60s (×7.63)
0.68s (×8.56)
1.27s (×16.00)
1.14s (×14.37)
0.76s (×9.65)
0.28s (×3.63)
0.31s (×4.03)
0.82s (×10.32)
0.25s (×3.24)
0.83s (×10.50)
0.24s (×3.07)
0.59s (×7.54)
0.72s (×9.09)
1.05s (×13.25)
0.44s (×5.65)
0.74s (×9.41)
0.91s (×11.53)
0.38s (×4.89)
1.52s (×19.07)
0.61s (×7.74)
1.24s (×15.63)
1.83s (×22.97)
0.74s (×9.36)
0.99s (×12.54)
2.50s (×31.35)
0.82s (×10.32)
3.91s (×48.97)
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)
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)
69.91s (×874.01)
285.83s (×3573.00)
267.47s (×3343.46)
286.57s (×3582.29)
267.50s (×3343.82)
306.66s (×3833.38)
419.90s (×5248.87)
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.30s (×2.41)
0.12s (×1.00)
0.36s (×2.88)
0.14s (×1.15)
0.84s (×6.54)
0.99s (×7.69)
0.60s (×4.72)
0.77s (×5.98)
1.04s (×8.08)
0.94s (×7.31)
0.85s (×6.59)
0.25s (×1.98)
0.29s (×2.32)
0.53s (×4.18)
0.29s (×2.34)
0.86s (×6.73)
0.59s (×4.60)
0.65s (×5.07)
0.70s (×5.50)
0.94s (×7.31)
0.34s (×2.67)
0.75s (×5.85)
1.06s (×8.22)
0.36s (×2.87)
1.58s (×12.24)
0.52s (×4.11)
0.55s (×4.31)
1.71s (×13.23)
0.79s (×6.16)
0.73s (×5.73)
2.61s (×20.14)
0.89s (×6.93)
4.07s (×31.37)
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)
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)
20.13s (×154.92)
389.23s (×2994.15)
267.47s (×2057.51)
287.18s (×2209.17)
267.69s (×2059.23)
305.12s (×2347.15)
432.88s (×3329.92)
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.68s (×2.21)
0.30s (×1.00)
1.03s (×3.36)
0.31s (×1.03)
0.87s (×2.84)
1.04s (×3.39)
1.71s (×5.54)
2.28s (×7.39)
1.05s (×3.42)
0.98s (×3.19)
1.68s (×5.45)
0.48s (×1.57)
0.42s (×1.38)
0.78s (×2.53)
0.48s (×1.57)
1.38s (×4.48)
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.72s (×5.59)
0.61s (×2.00)
3.56s (×11.50)
0.83s (×2.70)
0.89s (×2.90)
3.60s (×11.64)
1.91s (×6.19)
1.08s (×3.52)
6.77s (×21.88)
1.89s (×6.13)
8.00s (×25.84)
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)
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)
23.20s (×74.87)
575.06s (×1855.06)
263.10s (×848.73)
288.64s (×931.12)
263.12s (×848.81)
298.44s (×962.74)
420.73s (×1357.23)
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.94s (×16.70)
0.26s (×4.76)
1.35s (×24.04)
0.39s (×7.05)
0.29s (×5.29)
0.50s (×8.99)
2.11s (×37.35)
2.94s (×51.96)
0.73s (×13.04)
2.27s (×40.17)
2.51s (×44.40)
0.49s (×8.84)
0.70s (×12.44)
4.10s (×72.45)
0.42s (×7.66)
3.08s (×54.49)
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.67s (×64.85)
1.92s (×33.99)
4.89s (×86.25)
2.11s (×37.30)
2.15s (×38.05)
11.13s (×196.28)
5.96s (×105.20)
2.64s (×46.72)
9.55s (×168.47)
6.81s (×120.17)
14.65s (×258.28)
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)
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)
74.99s (×1321.42)
285.64s (×5032.58)
0.34s (×6.08)
287.13s (×5058.77)
267.49s (×4712.77)
309.90s (×5459.99)
545.45s (×9609.90)
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.08s (×7.14)
0.05s (×4.82)
0.09s (×8.30)
0.08s (×7.22)
0.04s (×4.01)
0.04s (×4.01)
0.22s (×18.30)
0.16s (×13.48)
0.09s (×8.03)
0.13s (×11.24)
0.22s (×18.14)
0.18s (×15.57)
0.20s (×16.77)
0.18s (×15.34)
0.18s (×15.57)
0.25s (×20.71)
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.28s (×23.28)
0.17s (×14.17)
0.24s (×20.04)
0.43s (×34.99)
0.20s (×16.85)
0.48s (×39.06)
0.23s (×18.93)
0.47s (×38.28)
0.47s (×38.86)
0.26s (×21.44)
0.47s (×38.79)
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.29s (×23.76)
1.95s (×157.39)
1.66s (×134.13)
2.83s (×227.70)
5.31s (×427.15)
2.73s (×220.02)
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)
11.39s (×915.22)
37.48s (×3008.98)
0.01s (×1.20)
286.87s (×23024.86)
263.14s (×21120.43)
275.00s (×22072.56)
386.37s (×31011.22)
901.80s (×72380.12)
Q25. Query 25: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY SearchPhrase LIMIT 10;
0.04s (×4.25)
0.14s (×12.50)
0.06s (×5.92)
0.05s (×5.00)
0.08s (×7.42)
0.08s (×7.50)
0.12s (×10.83)
0.13s (×11.67)
0.14s (×12.17)
0.13s (×11.58)
0.27s (×23.33)
0.12s (×10.83)
0.16s (×14.00)
0.17s (×14.92)
0.18s (×16.00)
0.18s (×16.04)
0.20s (×17.58)
0.18s (×15.92)
0.07s (×6.30)
0.14s (×12.50)
0.15s (×13.75)
0.16s (×14.17)
0.24s (×20.75)
0.17s (×15.25)
0.18s (×16.25)
0.16s (×14.25)
0.23s (×20.12)
0.30s (×25.50)
0.16s (×14.17)
0.37s (×31.95)
0.17s (×14.64)
0.38s (×32.67)
0.46s (×38.75)
0.25s (×21.91)
0.33s (×28.28)
0.51s (×43.25)
0.17s (×14.81)
0.35s (×30.00)
0.37s (×31.64)
0.85s (×71.33)
0.69s (×58.33)
2.06s (×172.65)
0.40s (×33.75)
2.72s (×227.33)
1.25s (×105.13)
2.57s (×214.75)
7.21s (×601.42)
2.96s (×247.17)
1.75s (×146.58)
3.59s (×299.75)
0.13s (×11.69)
1.29s (×108.17)
2.44s (×204.04)
☠
☠
8.47s (×706.56)
52.40s (×4367.57)
0.00s (×1.00)
72.07s (×6006.67)
263.09s (×21925.17)
288.59s (×24049.75)
263.10s (×21926.00)
277.46s (×23122.50)
385.05s (×32088.33)
898.30s (×74859.17)
Q26. Query 26: SELECT SearchPhrase FROM hits WHERE SearchPhrase <> '' ORDER BY EventTime, SearchPhrase LIMIT 10;
0.05s (×1.40)
0.04s (×1.25)
0.08s (×2.20)
0.05s (×1.50)
0.08s (×2.28)
0.07s (×2.00)
0.03s (×1.00)
0.04s (×1.25)
0.17s (×4.53)
0.15s (×4.08)
0.04s (×1.25)
0.14s (×3.75)
0.21s (×5.60)
0.19s (×4.90)
0.20s (×5.13)
0.19s (×4.89)
0.40s (×10.30)
0.23s (×5.88)
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.27s (×7.08)
0.18s (×4.71)
0.24s (×6.32)
0.31s (×8.10)
0.16s (×4.25)
0.49s (×12.39)
0.23s (×6.11)
0.47s (×12.02)
0.47s (×12.10)
0.29s (×7.50)
0.48s (×12.13)
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.50s (×12.72)
2.42s (×60.67)
1.47s (×36.90)
2.92s (×73.37)
9.05s (×226.53)
2.89s (×72.59)
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)
15.35s (×384.07)
40.11s (×1003.00)
0.34s (×8.73)
286.91s (×7173.00)
263.09s (×6577.45)
278.04s (×6951.25)
394.67s (×9867.00)
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.29s (×2.18)
0.47s (×3.43)
0.30s (×2.18)
0.13s (×1.00)
1.11s (×8.00)
1.16s (×8.36)
0.57s (×4.16)
0.78s (×5.61)
1.27s (×9.14)
1.18s (×8.50)
0.77s (×5.56)
0.40s (×2.91)
0.33s (×2.43)
0.47s (×3.43)
0.32s (×2.37)
0.76s (×5.51)
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.82s (×5.96)
0.39s (×2.88)
1.25s (×9.03)
0.64s (×4.62)
0.56s (×4.07)
1.47s (×10.59)
0.90s (×6.47)
1.19s (×8.59)
2.06s (×14.78)
0.85s (×6.17)
3.55s (×25.42)
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)
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)
109.01s (×778.69)
445.03s (×3178.86)
267.49s (×1910.72)
305.63s (×2183.11)
268.20s (×1915.81)
406.88s (×2906.36)
387.21s (×2765.86)
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.16s (×1.63)
0.24s (×2.40)
0.16s (×1.66)
0.17s (×1.73)
0.37s (×3.65)
0.37s (×3.65)
0.24s (×2.42)
0.39s (×3.83)
0.40s (×3.94)
0.42s (×4.13)
0.42s (×4.14)
0.37s (×3.69)
0.28s (×2.81)
0.57s (×5.60)
0.31s (×3.08)
0.44s (×4.29)
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.67)
0.34s (×3.41)
0.40s (×3.99)
0.54s (×5.26)
1.03s (×10.00)
0.92s (×8.96)
0.66s (×6.42)
0.83s (×8.08)
0.85s (×8.23)
1.07s (×10.35)
1.16s (×11.21)
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)
4.57s (×43.99)
2.34s (×22.57)
3.19s (×30.81)
2.95s (×28.49)
7.30s (×70.34)
21.03s (×202.35)
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)
4873.49s (×46860.56)
58.07s (×558.46)
274.00s (×2634.66)
295.18s (×2838.38)
270.29s (×2599.08)
331.94s (×3191.83)
489.59s (×4707.69)
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.25s (×1.60)
0.31s (×1.94)
0.20s (×1.30)
0.29s (×1.82)
0.42s (×2.61)
0.41s (×2.55)
0.37s (×2.32)
0.61s (×3.78)
0.51s (×3.15)
0.50s (×3.09)
0.51s (×3.16)
0.29s (×1.79)
0.40s (×2.51)
0.80s (×4.94)
0.36s (×2.26)
0.54s (×3.36)
0.34s (×2.12)
0.40s (×2.48)
0.37s (×2.30)
0.71s (×4.36)
0.41s (×2.56)
0.52s (×3.23)
1.19s (×7.27)
0.55s (×3.38)
0.59s (×3.62)
0.66s (×4.05)
1.45s (×8.85)
1.14s (×6.99)
1.11s (×6.82)
1.06s (×6.50)
1.07s (×6.55)
1.63s (×9.97)
2.07s (×12.59)
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)
5.01s (×30.41)
3.59s (×21.82)
4.00s (×24.33)
3.16s (×19.20)
8.76s (×53.12)
62.12s (×376.52)
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)
4748.19s (×28777.00)
78.92s (×478.36)
281.39s (×1705.45)
298.19s (×1807.27)
275.93s (×1672.33)
500.53s (×3033.58)
647.32s (×3923.21)
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.18s (×2.30)
1.30s (×2.54)
0.66s (×1.30)
1.04s (×2.04)
2.76s (×5.38)
2.75s (×5.36)
1.69s (×3.31)
4.04s (×7.86)
3.19s (×6.21)
3.16s (×6.16)
2.89s (×5.63)
0.51s (×1.00)
0.75s (×1.48)
4.72s (×9.19)
0.78s (×1.54)
2.06s (×4.03)
0.74s (×1.46)
1.79s (×3.50)
1.81s (×3.53)
5.13s (×9.98)
1.08s (×2.13)
2.09s (×4.07)
2.38s (×4.64)
2.77s (×5.41)
1.69s (×3.29)
1.68s (×3.28)
10.42s (×20.25)
5.28s (×10.28)
6.49s (×12.63)
3.62s (×7.05)
3.87s (×7.53)
11.25s (×21.87)
11.32s (×21.99)
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)
☠
33.64s (×65.34)
☠
8.54s (×16.60)
163.35s (×317.21)
☠
☠
129.74s (×251.94)
240.32s (×466.65)
912.19s (×1771.26)
504.96s (×980.52)
426.59s (×828.35)
376.96s (×731.99)
576.93s (×1120.28)
2681.96s (×5207.71)
2792.12s (×5421.61)
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)
0.96s (×1.93)
1.06s (×2.12)
0.92s (×1.84)
1.41s (×2.82)
4.04s (×8.04)
3.95s (×7.86)
1.31s (×2.63)
3.21s (×6.39)
4.73s (×9.40)
4.40s (×8.75)
2.65s (×5.28)
0.60s (×1.21)
0.83s (×1.68)
2.20s (×4.39)
0.71s (×1.43)
2.01s (×4.00)
0.78s (×1.58)
1.75s (×3.49)
1.68s (×3.34)
6.82s (×13.55)
1.27s (×2.54)
1.83s (×3.64)
2.33s (×4.63)
1.96s (×3.92)
2.82s (×5.62)
2.13s (×4.25)
9.61s (×19.09)
3.15s (×6.28)
4.53s (×9.01)
3.66s (×7.29)
5.26s (×10.46)
6.42s (×12.76)
7.68s (×15.25)
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)
☠
27.07s (×53.74)
☠
16.86s (×33.48)
91.70s (×181.97)
☠
0.49s (×1.00)
90.16s (×178.91)
460.47s (×913.64)
585.97s (×1162.66)
182468.89s (×362041.47)
418.21s (×829.80)
409.55s (×812.63)
439.78s (×872.60)
831.14s (×1649.11)
954.94s (×1894.74)
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.95s (×1.73)
0.98s (×1.79)
0.94s (×1.71)
1.40s (×2.55)
4.05s (×7.33)
4.03s (×7.29)
1.32s (×2.40)
3.13s (×5.67)
4.61s (×8.34)
4.27s (×7.73)
2.66s (×4.82)
0.61s (×1.12)
0.82s (×1.50)
2.23s (×4.04)
0.54s (×1.00)
1.94s (×3.52)
1.05s (×1.91)
1.48s (×2.69)
1.53s (×2.78)
6.82s (×12.33)
1.24s (×2.26)
1.78s (×3.23)
2.35s (×4.25)
1.91s (×3.46)
2.84s (×5.14)
2.11s (×3.83)
9.84s (×17.78)
3.19s (×5.77)
4.50s (×8.14)
3.61s (×6.54)
5.16s (×9.34)
6.38s (×11.54)
12.71s (×22.96)
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)
☠
26.81s (×48.42)
☠
16.85s (×30.43)
96.05s (×173.40)
☠
☠
94.48s (×170.56)
471.81s (×851.66)
570.28s (×1029.40)
182468.89s (×329366.25)
422.75s (×763.10)
453.71s (×818.99)
416.70s (×752.19)
830.46s (×1499.04)
953.78s (×1721.64)
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.37s (×2.55)
0.44s (×3.05)
0.14s (×1.00)
0.45s (×3.12)
0.41s (×2.84)
0.39s (×2.71)
0.41s (×2.85)
0.87s (×5.96)
1.28s (×8.74)
1.11s (×7.59)
0.92s (×6.27)
0.30s (×2.09)
0.36s (×2.51)
0.82s (×5.62)
0.34s (×2.36)
0.66s (×4.55)
0.33s (×2.28)
0.64s (×4.43)
0.60s (×4.13)
2.49s (×16.93)
0.39s (×2.73)
0.66s (×4.55)
0.81s (×5.57)
0.64s (×4.39)
0.31s (×2.19)
0.62s (×4.26)
1.79s (×12.19)
0.88s (×6.03)
1.31s (×8.96)
1.05s (×7.21)
0.65s (×4.45)
1.59s (×10.85)
2.12s (×14.43)
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)
5.93s (×40.26)
1.81s (×12.36)
9.90s (×67.13)
1.63s (×11.10)
3.93s (×26.68)
18.68s (×126.62)
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)
419.33s (×2840.53)
66.93s (×453.43)
296.94s (×2011.44)
346.73s (×2348.71)
295.14s (×1999.27)
608.51s (×4121.95)
708.75s (×4800.95)
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.84)
0.04s (×1.26)
0.07s (×2.12)
0.04s (×1.26)
0.30s (×7.84)
0.12s (×3.28)
0.05s (×1.51)
0.06s (×1.77)
0.12s (×3.15)
0.07s (×2.02)
0.06s (×1.77)
0.05s (×1.51)
0.09s (×2.62)
0.21s (×5.60)
0.19s (×4.95)
0.03s (×1.00)
0.22s (×5.83)
0.09s (×2.60)
0.55s (×14.21)
0.11s (×3.05)
0.07s (×1.99)
0.04s (×1.26)
0.19s (×5.05)
0.09s (×2.50)
0.07s (×2.04)
0.28s (×7.20)
0.96s (×24.39)
0.20s (×5.17)
0.14s (×3.79)
0.18s (×4.81)
0.28s (×7.29)
0.20s (×5.20)
1.88s (×47.71)
0.26s (×6.79)
0.48s (×12.28)
0.22s (×5.75)
0.32s (×8.38)
0.19s (×5.05)
0.23s (×6.12)
0.25s (×6.54)
3.60s (×91.20)
0.54s (×13.90)
0.20s (×5.35)
2.05s (×52.06)
0.17s (×4.53)
1.96s (×49.77)
0.32s (×8.33)
0.80s (×20.42)
1.79s (×45.35)
12.62s (×318.61)
0.49s (×12.63)
10.06s (×254.21)
0.54s (×13.91)
1.46s (×37.15)
0.26s (×6.69)
5.87s (×148.39)
3.34s (×84.56)
4.97s (×125.80)
3.61s (×91.36)
1.48s (×37.63)
0.76s (×19.36)
0.79s (×20.29)
4.13s (×104.48)
3.77s (×95.39)
2.77s (×70.16)
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.76)
0.03s (×1.72)
0.04s (×1.98)
0.04s (×2.15)
0.31s (×13.98)
0.09s (×4.30)
0.03s (×1.72)
0.03s (×1.72)
0.06s (×3.01)
0.03s (×1.59)
0.04s (×2.15)
0.02s (×1.29)
0.04s (×2.15)
0.14s (×6.41)
0.14s (×6.33)
0.01s (×1.00)
0.14s (×6.41)
0.05s (×2.58)
0.59s (×25.74)
0.04s (×2.24)
0.39s (×17.30)
0.03s (×1.72)
0.14s (×6.45)
0.04s (×2.19)
0.05s (×2.58)
0.20s (×9.23)
1.10s (×47.91)
0.15s (×6.97)
0.09s (×4.30)
0.14s (×6.37)
0.16s (×7.27)
0.14s (×6.41)
2.17s (×93.90)
0.20s (×9.07)
0.19s (×8.43)
0.13s (×6.20)
0.18s (×8.00)
0.08s (×3.87)
0.18s (×8.02)
0.14s (×6.67)
3.61s (×155.73)
0.33s (×14.73)
0.07s (×3.40)
1.52s (×66.01)
0.12s (×5.40)
2.15s (×93.12)
0.29s (×12.91)
0.74s (×32.31)
0.91s (×39.42)
13.83s (×595.60)
0.18s (×8.28)
7.82s (×336.98)
0.19s (×8.62)
0.91s (×39.47)
0.17s (×7.83)
1.81s (×78.14)
0.83s (×36.24)
1.63s (×70.40)
0.62s (×27.11)
0.94s (×40.75)
0.59s (×25.69)
0.56s (×24.44)
3.70s (×159.65)
3.27s (×141.14)
2.52s (×108.87)
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.23)
0.02s (×1.06)
0.03s (×1.52)
0.03s (×1.41)
0.07s (×2.66)
0.11s (×4.23)
0.02s (×1.06)
0.02s (×1.06)
0.06s (×2.36)
0.02s (×1.20)
0.02s (×1.06)
0.02s (×1.06)
0.04s (×1.62)
0.15s (×5.68)
0.13s (×5.01)
0.02s (×1.00)
0.14s (×5.15)
0.05s (×2.01)
0.42s (×15.28)
0.05s (×2.19)
0.19s (×6.91)
0.02s (×1.06)
0.14s (×5.32)
0.12s (×4.65)
0.05s (×2.15)
0.19s (×7.05)
0.11s (×4.13)
0.14s (×5.15)
0.08s (×3.17)
0.14s (×5.14)
0.14s (×5.29)
0.14s (×5.43)
0.23s (×8.39)
0.16s (×5.87)
0.14s (×5.37)
0.16s (×5.85)
0.16s (×5.97)
0.05s (×2.12)
0.15s (×5.53)
0.15s (×5.50)
3.74s (×132.24)
0.08s (×3.20)
0.03s (×1.55)
1.80s (×63.99)
0.10s (×3.78)
2.48s (×87.68)
0.25s (×9.24)
0.65s (×23.25)
0.09s (×3.56)
13.21s (×465.95)
0.05s (×2.27)
9.96s (×351.51)
0.14s (×5.17)
0.29s (×10.49)
0.26s (×9.38)
0.80s (×28.56)
0.31s (×11.16)
2.22s (×78.69)
0.18s (×6.70)
0.90s (×32.15)
0.24s (×8.74)
0.42s (×15.02)
1.45s (×51.47)
0.96s (×34.20)
1.52s (×53.94)
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 (×2.18)
0.06s (×1.15)
0.16s (×2.72)
0.19s (×3.28)
0.10s (×1.82)
0.22s (×3.77)
0.12s (×2.13)
0.10s (×1.80)
0.18s (×3.13)
0.14s (×2.49)
0.14s (×2.46)
0.12s (×2.13)
0.18s (×3.15)
0.30s (×5.02)
0.30s (×5.10)
0.05s (×1.00)
0.35s (×5.87)
0.12s (×2.13)
0.49s (×8.28)
0.13s (×2.25)
0.23s (×3.87)
0.14s (×2.46)
0.29s (×4.94)
0.11s (×2.00)
0.17s (×2.97)
0.39s (×6.58)
0.15s (×2.61)
0.29s (×4.92)
0.28s (×4.76)
0.32s (×5.34)
0.43s (×7.29)
0.29s (×4.87)
0.28s (×4.68)
0.45s (×7.55)
1.14s (×18.93)
0.32s (×5.40)
0.56s (×9.36)
0.36s (×6.07)
0.42s (×7.05)
0.36s (×6.00)
6.26s (×102.89)
0.69s (×11.46)
0.65s (×10.84)
2.79s (×45.97)
0.27s (×4.51)
3.58s (×58.95)
0.62s (×10.35)
0.94s (×15.52)
1.13s (×18.75)
22.95s (×376.67)
1.14s (×18.80)
16.06s (×263.65)
1.49s (×24.64)
☠
0.18s (×3.08)
7.71s (×126.61)
4.54s (×74.64)
8.76s (×143.88)
563.02s (×9234.80)
1.77s (×29.20)
1.52s (×25.09)
1.31s (×21.67)
5.14s (×84.47)
4.68s (×76.93)
3.57s (×58.72)
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.45)
0.02s (×1.55)
0.02s (×1.65)
0.10s (×5.68)
0.05s (×2.93)
0.07s (×4.13)
0.01s (×1.03)
0.02s (×1.55)
0.04s (×2.37)
0.01s (×1.29)
0.02s (×1.55)
0.02s (×1.55)
0.02s (×1.50)
0.14s (×7.95)
0.17s (×9.29)
0.01s (×1.00)
0.13s (×7.33)
0.03s (×1.86)
0.50s (×26.42)
0.04s (×2.63)
0.29s (×15.33)
0.02s (×1.55)
0.14s (×7.64)
0.15s (×8.16)
0.03s (×1.91)
0.14s (×7.67)
0.04s (×2.74)
0.13s (×7.18)
0.02s (×1.55)
0.08s (×4.68)
0.15s (×8.04)
0.12s (×6.66)
0.08s (×4.51)
0.14s (×7.64)
0.05s (×3.29)
0.13s (×7.38)
0.10s (×5.82)
0.03s (×2.07)
0.18s (×9.85)
0.13s (×7.38)
0.84s (×43.68)
0.15s (×8.24)
0.07s (×4.18)
2.08s (×108.00)
0.11s (×5.95)
2.61s (×135.41)
0.11s (×5.99)
0.67s (×35.07)
0.06s (×3.72)
1.52s (×79.09)
0.13s (×7.46)
0.14s (×7.95)
0.14s (×7.65)
0.36s (×19.05)
0.11s (×6.30)
0.64s (×33.48)
0.30s (×15.88)
0.45s (×23.49)
0.11s (×6.20)
1.97s (×101.96)
0.28s (×15.13)
0.61s (×32.27)
1.41s (×73.31)
0.74s (×38.72)
0.94s (×49.04)
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.55)
0.02s (×1.61)
0.02s (×1.66)
0.11s (×6.42)
0.05s (×3.07)
0.16s (×9.10)
0.02s (×1.61)
0.02s (×1.61)
0.03s (×2.25)
0.01s (×1.07)
0.02s (×1.61)
0.02s (×1.61)
0.01s (×1.23)
0.12s (×7.01)
0.17s (×9.85)
0.01s (×1.00)
0.12s (×7.17)
0.03s (×2.03)
0.23s (×12.93)
0.04s (×2.73)
0.03s (×2.03)
0.01s (×1.07)
0.15s (×8.56)
0.02s (×1.77)
0.02s (×1.82)
0.13s (×7.62)
0.04s (×2.79)
0.13s (×7.38)
0.01s (×1.07)
0.08s (×5.01)
0.12s (×6.95)
0.14s (×7.87)
0.08s (×4.57)
0.13s (×7.34)
0.04s (×2.85)
0.12s (×6.96)
0.15s (×8.76)
0.02s (×1.61)
0.12s (×7.03)
0.14s (×7.76)
0.72s (×38.85)
0.07s (×4.39)
0.04s (×2.51)
1.95s (×104.66)
0.12s (×6.81)
1.82s (×97.92)
0.10s (×5.83)
0.65s (×35.29)
0.06s (×3.80)
1.42s (×76.30)
0.06s (×3.54)
0.13s (×7.54)
0.12s (×7.12)
0.30s (×16.42)
0.12s (×6.74)
0.68s (×36.93)
0.28s (×15.39)
0.39s (×21.30)
0.08s (×4.82)
1.43s (×77.05)
0.31s (×17.34)
0.54s (×29.16)
1.39s (×74.91)
0.75s (×40.67)
0.91s (×49.23)
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;