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.03s (×2.00)
0.01s (×1.20)
0.01s (×1.10)
0.01s (×1.15)
0.02s (×1.50)
0.01s (×1.00)
0.03s (×1.88)
0.03s (×2.00)
0.00s (×0.50)
0.01s (×1.09)
0.02s (×1.50)
0.04s (×2.50)
0.03s (×2.00)
0.07s (×3.90)
0.03s (×1.82)
0.01s (×1.00)
0.01s (×1.00)
0.01s (×1.05)
0.04s (×2.50)
0.03s (×2.00)
0.01s (×1.05)
1.25s (×63.10)
0.07s (×4.05)
0.02s (×1.45)
0.32s (×16.70)
0.03s (×1.94)
1.93s (×96.85)
0.03s (×1.99)
0.01s (×1.00)
0.08s (×4.40)
0.03s (×2.15)
0.24s (×12.50)
0.02s (×1.50)
0.02s (×1.30)
0.11s (×5.76)
0.02s (×1.60)
0.07s (×4.05)
0.03s (×2.06)
0.19s (×10.00)
0.03s (×2.00)
0.00s (×0.50)
0.15s (×7.90)
0.05s (×3.20)
0.12s (×6.50)
0.09s (×4.90)
0.41s (×20.85)
0.09s (×5.06)
0.04s (×2.56)
0.03s (×2.00)
0.12s (×6.53)
0.08s (×4.45)
0.31s (×16.05)
0.02s (×1.42)
0.28s (×14.30)
0.01s (×1.00)
0.10s (×5.70)
0.06s (×3.54)
0.08s (×4.45)
0.12s (×6.58)
0.39s (×19.80)
0.37s (×18.80)
0.10s (×5.45)
0.90s (×45.70)
0.05s (×3.02)
0.18s (×9.75)
2.25s (×112.90)
1.02s (×51.43)
3.14s (×157.30)
0.18s (×9.37)
0.02s (×1.66)
0.15s (×8.15)
0.10s (×5.55)
0.13s (×7.19)
1.67s (×83.85)
1.40s (×70.53)
0.27s (×14.05)
0.04s (×2.50)
0.05s (×2.90)
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.04s (×2.45)
0.06s (×3.50)
0.02s (×1.54)
0.02s (×1.50)
0.02s (×1.65)
0.04s (×2.50)
0.02s (×1.40)
0.04s (×2.31)
0.03s (×1.85)
0.01s (×1.00)
0.02s (×1.48)
0.03s (×2.07)
0.06s (×3.50)
0.05s (×3.00)
0.04s (×2.25)
0.05s (×2.81)
0.03s (×1.75)
0.02s (×1.50)
0.02s (×1.65)
0.03s (×2.00)
0.07s (×4.00)
0.03s (×1.80)
0.33s (×16.75)
0.09s (×4.75)
0.05s (×3.00)
0.28s (×14.25)
0.06s (×3.31)
0.22s (×11.60)
0.04s (×2.42)
0.03s (×1.90)
0.09s (×5.00)
0.06s (×3.38)
1.05s (×53.05)
0.04s (×2.45)
0.05s (×2.90)
0.12s (×6.56)
0.06s (×3.28)
0.09s (×5.05)
0.04s (×2.75)
0.57s (×28.80)
0.07s (×4.10)
0.09s (×5.00)
0.20s (×10.65)
0.10s (×5.37)
0.10s (×5.54)
0.14s (×7.35)
0.27s (×13.80)
0.14s (×7.61)
0.11s (×5.94)
0.11s (×6.20)
0.15s (×8.04)
0.16s (×8.70)
0.43s (×21.80)
0.03s (×2.25)
0.63s (×32.05)
0.15s (×8.00)
0.17s (×8.75)
0.12s (×6.47)
0.14s (×7.40)
0.16s (×8.50)
0.56s (×28.50)
0.35s (×18.15)
0.40s (×20.45)
1.22s (×61.30)
0.03s (×1.87)
0.26s (×13.40)
2.32s (×116.30)
2.42s (×121.60)
3.64s (×182.50)
0.93s (×47.04)
0.05s (×3.21)
0.40s (×20.40)
1.23s (×61.80)
2.47s (×124.10)
13.99s (×700.05)
3.59s (×180.17)
0.15s (×8.08)
0.09s (×5.15)
0.05s (×2.85)
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.03s (×1.75)
0.06s (×3.50)
0.02s (×1.46)
0.02s (×1.60)
0.02s (×1.65)
0.06s (×3.50)
0.02s (×1.55)
0.06s (×3.44)
0.03s (×1.95)
0.01s (×1.00)
0.02s (×1.34)
0.03s (×2.01)
0.06s (×3.50)
0.05s (×3.00)
0.04s (×2.25)
0.04s (×2.62)
0.03s (×2.05)
0.03s (×1.80)
0.03s (×1.95)
0.04s (×2.50)
0.09s (×5.00)
0.03s (×2.20)
0.18s (×9.55)
0.09s (×4.90)
0.04s (×2.50)
0.17s (×8.80)
0.05s (×2.75)
0.21s (×10.80)
0.04s (×2.31)
0.04s (×2.55)
0.09s (×5.15)
0.05s (×3.09)
0.18s (×9.40)
0.06s (×3.60)
0.07s (×3.80)
0.11s (×5.84)
0.18s (×9.36)
0.35s (×18.15)
0.06s (×3.52)
0.26s (×13.70)
0.10s (×5.50)
0.08s (×4.50)
0.17s (×8.85)
0.08s (×4.39)
0.15s (×7.91)
0.17s (×8.85)
0.30s (×15.55)
0.22s (×11.42)
0.30s (×15.42)
0.15s (×8.15)
0.13s (×6.77)
0.23s (×12.10)
0.40s (×20.70)
0.03s (×1.96)
0.48s (×24.50)
0.08s (×4.50)
0.16s (×8.45)
0.19s (×10.13)
0.13s (×6.75)
0.20s (×10.50)
0.54s (×27.40)
0.32s (×16.40)
0.52s (×26.60)
0.98s (×49.70)
0.01s (×1.10)
0.24s (×12.40)
2.31s (×116.20)
1.74s (×87.43)
2.51s (×126.20)
0.67s (×33.96)
0.05s (×3.24)
0.36s (×18.45)
0.74s (×37.30)
0.51s (×25.86)
6.69s (×335.20)
2.81s (×140.87)
0.13s (×6.95)
0.04s (×2.45)
0.05s (×2.80)
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;
0.09s (×1.10)
0.08s (×1.00)
0.25s (×2.84)
0.19s (×2.21)
0.20s (×2.34)
0.15s (×1.78)
0.19s (×2.21)
0.11s (×1.32)
0.18s (×2.17)
0.23s (×2.67)
0.36s (×4.13)
0.42s (×4.81)
0.28s (×3.22)
0.27s (×3.11)
0.22s (×2.57)
0.38s (×4.31)
0.30s (×3.43)
0.33s (×3.79)
0.35s (×3.97)
1.05s (×11.78)
0.33s (×3.78)
0.32s (×3.64)
0.27s (×3.06)
0.23s (×2.67)
0.25s (×2.92)
0.26s (×2.96)
0.75s (×8.50)
0.37s (×4.26)
0.30s (×3.47)
0.30s (×3.49)
0.24s (×2.76)
0.86s (×9.63)
0.31s (×3.58)
0.28s (×3.23)
1.54s (×17.28)
0.32s (×3.61)
0.30s (×3.45)
0.30s (×3.46)
1.48s (×16.58)
0.49s (×5.54)
0.56s (×6.29)
1.32s (×14.78)
0.46s (×5.21)
0.79s (×8.87)
0.64s (×7.18)
0.60s (×6.77)
0.82s (×9.28)
0.84s (×9.41)
0.58s (×6.58)
0.87s (×9.74)
1.03s (×11.60)
0.71s (×8.03)
1.35s (×15.10)
4.51s (×50.23)
0.52s (×5.87)
1.20s (×13.44)
0.48s (×5.46)
1.28s (×14.34)
2.72s (×30.30)
2.47s (×27.54)
2.51s (×27.96)
1.97s (×21.96)
1.72s (×19.17)
0.98s (×10.96)
8.12s (×90.30)
3.63s (×40.48)
2.88s (×32.07)
9.72s (×108.11)
2.19s (×24.40)
21.11s (×234.71)
6.16s (×68.60)
2.18s (×24.37)
2.00s (×22.38)
☠
4.41s (×49.14)
38.05s (×422.94)
2.52s (×28.06)
☠
0.68s (×7.62)
38.12s (×423.65)
48.02s (×533.70)
25.62s (×284.76)
15.69s (×174.44)
330.85s (×3676.24)
48.45s (×538.47)
42.33s (×470.49)
40.81s (×453.56)
384.86s (×4276.33)
842.40s (×9360.11)
Q5. Query 5: SELECT COUNT(DISTINCT SearchPhrase) FROM hits;
0.12s (×1.00)
0.21s (×1.69)
0.27s (×2.12)
0.40s (×3.15)
0.45s (×3.56)
0.28s (×2.23)
0.23s (×1.87)
0.18s (×1.43)
0.25s (×1.98)
0.25s (×2.00)
0.38s (×3.00)
0.58s (×4.53)
0.61s (×4.77)
0.57s (×4.46)
0.32s (×2.56)
0.51s (×4.03)
0.43s (×3.39)
0.47s (×3.65)
0.52s (×4.11)
0.76s (×5.92)
0.84s (×6.54)
0.51s (×4.02)
0.30s (×2.37)
0.33s (×2.65)
0.42s (×3.29)
0.33s (×2.58)
0.69s (×5.42)
0.33s (×2.58)
0.33s (×2.65)
0.72s (×5.63)
0.48s (×3.79)
0.79s (×6.17)
0.42s (×3.31)
0.78s (×6.04)
1.10s (×8.54)
0.35s (×2.74)
0.45s (×3.57)
0.66s (×5.18)
0.76s (×5.93)
0.65s (×5.08)
1.21s (×9.38)
1.95s (×15.08)
0.70s (×5.46)
0.89s (×6.94)
0.56s (×4.41)
1.18s (×9.13)
1.02s (×7.95)
0.61s (×4.80)
1.06s (×8.24)
1.63s (×12.63)
1.21s (×9.36)
1.77s (×13.68)
1.70s (×13.13)
4.27s (×32.92)
0.80s (×6.22)
2.63s (×20.31)
0.78s (×6.10)
0.98s (×7.64)
1.75s (×13.56)
1.87s (×14.44)
2.65s (×20.45)
4.08s (×31.46)
3.71s (×28.60)
1.22s (×9.45)
9.39s (×72.27)
14.69s (×113.05)
2.70s (×20.83)
4.10s (×31.62)
2.74s (×21.17)
32.63s (×251.11)
8.62s (×66.40)
6.05s (×46.65)
3.75s (×28.96)
☠
156.14s (×1201.17)
65.64s (×504.98)
6.50s (×50.10)
☠
0.20s (×1.64)
113.44s (×872.70)
282.44s (×2172.66)
10.20s (×78.57)
42.37s (×326.00)
356.80s (×2744.70)
344.88s (×2653.03)
356.31s (×2740.96)
467.39s (×3595.38)
574.68s (×4420.69)
869.75s (×6690.46)
Q6. Query 6: SELECT MIN(EventDate), MAX(EventDate) FROM hits;
0.02s (×2.15)
0.02s (×2.31)
0.01s (×1.91)
0.02s (×2.15)
0.02s (×2.00)
0.01s (×1.54)
0.01s (×1.92)
0.03s (×2.98)
0.02s (×2.08)
0.00s (×0.77)
0.01s (×1.87)
0.01s (×1.86)
0.01s (×1.54)
0.02s (×2.31)
0.02s (×2.31)
0.02s (×2.63)
0.02s (×2.15)
0.02s (×2.15)
0.02s (×2.23)
0.02s (×2.31)
0.02s (×2.31)
0.02s (×2.31)
0.06s (×5.54)
0.07s (×6.23)
0.04s (×3.77)
0.06s (×5.38)
0.05s (×4.54)
0.05s (×4.69)
0.14s (×11.40)
0.02s (×2.15)
0.08s (×7.23)
0.05s (×4.69)
0.05s (×4.92)
0.02s (×2.62)
0.02s (×2.62)
0.10s (×8.83)
0.04s (×3.59)
0.07s (×6.38)
0.03s (×3.17)
0.06s (×5.00)
0.04s (×3.77)
0.00s (×0.77)
0.17s (×13.85)
0.17s (×13.96)
0.11s (×8.87)
0.09s (×7.31)
0.06s (×5.54)
0.10s (×8.63)
0.08s (×7.09)
0.04s (×4.15)
0.12s (×9.79)
0.12s (×9.62)
0.06s (×5.31)
0.06s (×5.63)
0.28s (×22.69)
0.00s (×0.77)
0.11s (×9.38)
0.06s (×5.64)
0.08s (×6.62)
0.11s (×9.31)
0.05s (×4.62)
0.10s (×8.31)
0.16s (×12.85)
0.60s (×46.92)
0.03s (×3.05)
☠
2.20s (×169.92)
1.90s (×146.74)
1.98s (×153.38)
0.72s (×55.95)
0.05s (×4.75)
0.23s (×18.31)
0.74s (×57.38)
1.07s (×82.77)
6.21s (×478.15)
2.84s (×219.52)
☠
0.09s (×7.92)
0.05s (×4.38)
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.97)
0.04s (×2.99)
0.02s (×1.69)
0.03s (×2.09)
0.02s (×2.03)
0.02s (×1.79)
0.02s (×1.97)
0.03s (×2.62)
0.02s (×1.97)
0.01s (×1.20)
0.01s (×1.00)
0.02s (×1.92)
0.02s (×1.79)
0.02s (×1.79)
0.04s (×2.75)
0.03s (×2.31)
0.01s (×1.43)
0.01s (×1.31)
0.01s (×1.43)
0.03s (×2.39)
0.03s (×2.39)
0.01s (×1.49)
0.19s (×12.19)
0.09s (×5.74)
0.03s (×2.27)
0.28s (×17.33)
0.03s (×2.60)
0.36s (×21.99)
0.22s (×13.64)
0.01s (×1.49)
0.08s (×5.14)
0.03s (×2.61)
0.20s (×12.55)
0.03s (×2.33)
0.02s (×1.79)
0.12s (×7.88)
0.02s (×2.02)
0.10s (×6.33)
0.06s (×3.91)
0.31s (×18.94)
0.04s (×2.93)
0.01s (×1.20)
0.16s (×10.40)
0.05s (×3.83)
0.13s (×8.31)
0.09s (×5.74)
0.25s (×15.77)
0.11s (×6.95)
0.04s (×3.27)
0.03s (×2.57)
0.12s (×7.62)
0.10s (×6.57)
0.51s (×30.95)
0.02s (×1.85)
0.23s (×14.64)
0.02s (×1.79)
0.10s (×6.69)
0.07s (×4.77)
0.08s (×5.44)
0.13s (×8.28)
0.39s (×23.72)
0.07s (×4.54)
0.14s (×9.26)
0.48s (×29.46)
0.19s (×11.75)
0.13s (×8.60)
3.07s (×184.15)
1.00s (×60.31)
2.40s (×144.18)
0.18s (×11.31)
0.21s (×13.07)
0.19s (×11.89)
0.10s (×6.75)
0.07s (×4.66)
1.71s (×102.71)
1.19s (×71.84)
0.27s (×16.96)
0.04s (×2.87)
0.05s (×3.59)
4.73s (×283.11)
53.53s (×3199.08)
0.64s (×39.08)
2.42s (×145.19)
263.02s (×15715.94)
286.88s (×17141.77)
263.17s (×15724.84)
275.30s (×16449.92)
384.02s (×22945.99)
829.25s (×49548.72)
Q8. Query 8: SELECT RegionID, COUNT(DISTINCT UserID) AS u FROM hits GROUP BY RegionID ORDER BY u DESC LIMIT 10;
0.14s (×1.13)
0.12s (×1.00)
0.29s (×2.29)
0.25s (×1.98)
0.27s (×2.12)
0.33s (×2.62)
0.38s (×2.97)
0.13s (×1.10)
0.38s (×3.03)
0.31s (×2.46)
0.39s (×3.04)
0.52s (×4.11)
0.47s (×3.69)
0.45s (×3.54)
0.41s (×3.25)
0.58s (×4.56)
0.61s (×4.75)
0.87s (×6.75)
0.51s (×3.98)
0.54s (×4.23)
0.47s (×3.69)
0.56s (×4.35)
0.32s (×2.53)
0.41s (×3.19)
0.43s (×3.40)
0.31s (×2.49)
0.83s (×6.49)
0.48s (×3.75)
0.68s (×5.32)
0.54s (×4.21)
0.42s (×3.28)
0.95s (×7.38)
0.37s (×2.89)
0.55s (×4.27)
0.61s (×4.80)
0.44s (×3.49)
0.47s (×3.66)
0.48s (×3.76)
0.33s (×2.62)
0.59s (×4.64)
0.73s (×5.69)
1.71s (×13.23)
0.56s (×4.38)
0.90s (×7.02)
0.89s (×6.93)
0.81s (×6.32)
0.95s (×7.40)
1.31s (×10.18)
0.87s (×6.75)
1.08s (×8.35)
1.51s (×11.73)
0.94s (×7.32)
1.63s (×12.62)
4.41s (×33.98)
0.70s (×5.50)
1.39s (×10.77)
0.64s (×5.01)
0.72s (×5.61)
3.05s (×23.57)
3.74s (×28.87)
2.99s (×23.10)
3.43s (×26.43)
2.20s (×17.00)
1.04s (×8.09)
10.98s (×84.56)
2.90s (×22.40)
2.48s (×19.13)
7.76s (×59.75)
2.01s (×15.57)
26.50s (×203.95)
9.73s (×74.93)
2.62s (×20.23)
2.03s (×15.68)
☠
16.05s (×123.54)
47.01s (×361.71)
10.60s (×81.60)
☠
0.56s (×4.35)
76.92s (×591.78)
131.10s (×1008.55)
377.01s (×2900.17)
22.21s (×170.92)
319.39s (×2456.91)
354.13s (×2724.12)
321.92s (×2476.37)
325.35s (×2502.77)
495.68s (×3813.00)
909.46s (×6995.92)
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.70s (×2.54)
0.30s (×1.13)
0.27s (×1.01)
0.27s (×1.00)
0.34s (×1.25)
0.40s (×1.47)
1.41s (×5.10)
0.40s (×1.48)
0.85s (×3.08)
0.56s (×2.05)
0.60s (×2.17)
0.55s (×2.01)
0.50s (×1.83)
0.42s (×1.53)
0.66s (×2.41)
0.58s (×2.10)
0.52s (×1.89)
0.55s (×2.00)
0.61s (×2.22)
1.47s (×5.30)
0.61s (×2.23)
0.41s (×1.51)
0.41s (×1.51)
0.45s (×1.66)
0.42s (×1.53)
1.15s (×4.15)
0.50s (×1.82)
1.55s (×5.57)
0.61s (×2.23)
0.50s (×1.81)
1.31s (×4.74)
0.50s (×1.82)
0.61s (×2.24)
0.71s (×2.59)
0.93s (×3.38)
3.53s (×12.69)
0.56s (×2.05)
0.38s (×1.39)
0.86s (×3.12)
0.83s (×3.00)
5.10s (×18.32)
0.60s (×2.18)
1.29s (×4.67)
1.09s (×3.93)
0.95s (×3.44)
1.17s (×4.23)
5.36s (×19.26)
2.31s (×8.33)
1.26s (×4.56)
1.42s (×5.12)
1.15s (×4.17)
1.91s (×6.87)
6.55s (×23.51)
0.92s (×3.33)
3.48s (×12.51)
0.78s (×2.82)
0.89s (×3.22)
3.56s (×12.81)
5.14s (×18.46)
3.63s (×13.04)
2.76s (×9.93)
3.75s (×13.48)
1.46s (×5.27)
14.38s (×51.59)
3.21s (×11.55)
2.78s (×10.01)
11.26s (×40.38)
4.43s (×15.93)
26.39s (×94.63)
16.46s (×59.04)
3.42s (×12.31)
4.27s (×15.34)
☠
32.35s (×115.99)
51.27s (×183.80)
12.34s (×44.26)
☠
1.73s (×6.23)
82.47s (×295.64)
136.92s (×490.79)
2617.01s (×9380.00)
31.71s (×113.69)
322.22s (×1154.96)
362.26s (×1298.46)
326.17s (×1169.10)
336.95s (×1207.74)
635.96s (×2279.46)
932.32s (×3341.68)
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.17)
0.05s (×1.00)
0.29s (×4.94)
0.09s (×1.67)
0.10s (×1.82)
0.11s (×2.00)
0.13s (×2.37)
0.09s (×1.65)
0.14s (×2.55)
0.09s (×1.67)
0.27s (×4.71)
0.18s (×3.09)
0.11s (×2.00)
0.11s (×2.00)
0.21s (×3.72)
0.25s (×4.40)
0.17s (×2.98)
0.28s (×4.92)
0.15s (×2.63)
0.11s (×2.00)
0.10s (×1.83)
0.20s (×3.43)
0.25s (×4.28)
0.19s (×3.28)
0.20s (×3.50)
0.24s (×4.18)
0.31s (×5.36)
0.30s (×5.22)
0.66s (×11.21)
0.22s (×3.90)
0.21s (×3.65)
0.27s (×4.62)
0.29s (×5.05)
0.23s (×3.98)
0.23s (×4.02)
0.14s (×2.48)
0.16s (×2.86)
0.34s (×5.83)
0.22s (×3.90)
0.37s (×6.33)
0.35s (×6.03)
0.25s (×4.33)
0.43s (×7.40)
0.25s (×4.40)
0.23s (×3.98)
0.54s (×9.18)
0.46s (×7.77)
0.28s (×4.78)
0.29s (×5.01)
0.90s (×15.13)
0.30s (×5.20)
0.76s (×12.87)
0.59s (×9.95)
0.23s (×4.01)
0.61s (×10.42)
0.22s (×3.83)
0.36s (×6.18)
0.38s (×6.52)
0.40s (×6.78)
0.50s (×8.55)
0.97s (×16.27)
1.05s (×17.65)
1.19s (×19.92)
0.83s (×14.00)
11.66s (×194.55)
4.20s (×70.12)
2.05s (×34.28)
1.96s (×32.75)
3.15s (×52.75)
2.59s (×43.34)
9.53s (×158.96)
1.50s (×25.13)
1.40s (×23.53)
1.29s (×21.61)
1.77s (×29.70)
4.68s (×78.17)
0.82s (×13.86)
☠
☠
10.08s (×168.19)
56.22s (×937.09)
389.20s (×6486.85)
14.11s (×235.33)
265.38s (×4423.08)
293.89s (×4898.30)
265.68s (×4428.18)
279.87s (×4664.67)
396.49s (×6608.33)
854.74s (×14245.83)
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.06s (×1.06)
0.18s (×2.83)
0.10s (×1.65)
0.09s (×1.52)
0.10s (×1.67)
0.14s (×2.33)
0.10s (×1.71)
0.16s (×2.52)
0.08s (×1.36)
0.40s (×6.21)
0.18s (×2.90)
0.10s (×1.67)
0.12s (×1.97)
0.17s (×2.73)
0.25s (×4.01)
0.19s (×3.00)
0.21s (×3.38)
0.16s (×2.64)
0.13s (×2.12)
0.12s (×1.97)
0.21s (×3.30)
0.25s (×3.94)
0.21s (×3.32)
0.19s (×3.09)
0.23s (×3.71)
0.25s (×3.96)
0.29s (×4.55)
0.33s (×5.08)
0.23s (×3.70)
0.23s (×3.58)
0.30s (×4.63)
0.34s (×5.29)
0.24s (×3.79)
0.27s (×4.23)
0.17s (×2.67)
0.17s (×2.68)
0.27s (×4.30)
0.24s (×3.75)
0.37s (×5.74)
0.36s (×5.58)
0.25s (×3.94)
0.39s (×6.06)
0.30s (×4.64)
0.22s (×3.49)
0.59s (×9.12)
0.49s (×7.65)
0.28s (×4.38)
0.31s (×4.90)
0.60s (×9.29)
0.32s (×4.97)
0.81s (×12.35)
0.63s (×9.71)
0.27s (×4.18)
0.52s (×8.06)
0.23s (×3.64)
0.40s (×6.24)
0.43s (×6.68)
0.42s (×6.56)
0.56s (×8.57)
1.07s (×16.41)
1.18s (×18.02)
1.38s (×21.02)
0.86s (×13.20)
12.27s (×186.05)
4.12s (×62.59)
1.97s (×29.98)
1.98s (×30.14)
3.06s (×46.59)
2.63s (×39.94)
9.34s (×141.67)
1.76s (×26.88)
1.42s (×21.67)
1.27s (×19.38)
2.21s (×33.67)
5.55s (×84.26)
0.44s (×6.83)
☠
☠
11.19s (×169.66)
55.96s (×847.98)
384.64s (×5828.00)
16.53s (×250.61)
265.46s (×4022.30)
291.73s (×4420.29)
265.34s (×4020.39)
282.00s (×4272.88)
412.55s (×6250.91)
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.17s (×1.22)
0.29s (×2.04)
0.17s (×1.20)
0.18s (×1.32)
0.23s (×1.63)
0.21s (×1.52)
0.16s (×1.15)
0.23s (×1.65)
0.26s (×1.84)
0.31s (×2.18)
0.68s (×4.68)
0.55s (×3.81)
0.49s (×3.40)
0.32s (×2.24)
0.64s (×4.41)
0.48s (×3.35)
0.52s (×3.61)
0.56s (×3.86)
0.58s (×4.01)
0.54s (×3.74)
0.49s (×3.44)
0.29s (×2.03)
0.32s (×2.26)
0.59s (×4.09)
0.33s (×2.29)
0.58s (×4.00)
0.32s (×2.24)
0.34s (×2.41)
0.86s (×5.90)
0.49s (×3.43)
0.68s (×4.67)
0.37s (×2.59)
0.71s (×4.90)
0.69s (×4.78)
0.41s (×2.84)
0.48s (×3.33)
0.71s (×4.93)
0.32s (×2.23)
0.57s (×3.92)
1.23s (×8.46)
1.74s (×11.90)
0.62s (×4.27)
0.76s (×5.23)
0.75s (×5.18)
1.01s (×6.93)
0.89s (×6.11)
0.52s (×3.58)
1.09s (×7.45)
1.51s (×10.32)
1.39s (×9.55)
1.43s (×9.80)
1.40s (×9.62)
3.07s (×20.98)
0.74s (×5.08)
2.25s (×15.37)
0.91s (×6.26)
0.84s (×5.76)
2.04s (×13.95)
2.05s (×14.01)
2.04s (×13.91)
3.43s (×23.41)
2.98s (×20.35)
1.14s (×7.82)
7.78s (×53.00)
3.15s (×21.46)
1.94s (×13.23)
2.93s (×19.99)
2.58s (×17.59)
6.25s (×42.60)
9.17s (×62.46)
4.72s (×32.21)
3.61s (×24.63)
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)
70.31s (×478.39)
1961.40s (×13342.93)
276.30s (×1879.66)
298.18s (×2028.50)
282.23s (×1920.03)
334.83s (×2277.82)
448.06s (×3048.10)
☠
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.23s (×1.29)
0.43s (×2.36)
0.21s (×1.18)
0.24s (×1.37)
0.75s (×4.09)
0.30s (×1.67)
0.31s (×1.70)
0.35s (×1.93)
0.43s (×2.37)
0.53s (×2.92)
1.05s (×5.69)
0.92s (×5.00)
0.93s (×5.05)
0.40s (×2.19)
1.04s (×5.64)
0.73s (×3.99)
0.76s (×4.15)
0.81s (×4.43)
0.88s (×4.78)
0.96s (×5.22)
0.79s (×4.28)
0.39s (×2.16)
0.66s (×3.58)
0.74s (×4.03)
0.49s (×2.70)
0.99s (×5.36)
0.44s (×2.40)
0.61s (×3.31)
0.99s (×5.40)
0.77s (×4.19)
1.11s (×6.02)
0.58s (×3.18)
0.95s (×5.16)
1.04s (×5.67)
2.86s (×15.41)
0.92s (×5.02)
0.95s (×5.18)
0.37s (×2.04)
0.98s (×5.30)
1.51s (×8.18)
3.40s (×18.33)
0.73s (×3.96)
1.21s (×6.54)
3.43s (×18.50)
1.94s (×10.47)
1.65s (×8.90)
1.04s (×5.62)
1.96s (×10.60)
2.69s (×14.53)
6.56s (×35.34)
2.65s (×14.31)
2.55s (×13.78)
7.76s (×41.77)
0.91s (×4.95)
4.62s (×24.89)
1.23s (×6.68)
1.23s (×6.66)
3.71s (×19.98)
9.24s (×49.75)
3.63s (×19.55)
5.21s (×28.09)
5.14s (×27.69)
1.62s (×8.78)
25.65s (×137.98)
6.37s (×34.32)
3.07s (×16.56)
4.02s (×21.65)
3.08s (×16.64)
10.00s (×53.82)
16.83s (×90.55)
6.04s (×32.55)
4.73s (×25.48)
☠
5.19s (×27.94)
14.91s (×80.22)
7.26s (×39.09)
☠
☠
72.52s (×389.93)
96.47s (×518.73)
133.42s (×717.34)
1167.00s (×6274.25)
279.25s (×1501.40)
301.15s (×1619.14)
279.45s (×1502.50)
307.30s (×1652.20)
813.60s (×4374.25)
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.18s (×1.17)
0.27s (×1.73)
0.17s (×1.12)
0.21s (×1.38)
0.30s (×1.90)
0.23s (×1.45)
0.18s (×1.18)
0.27s (×1.69)
0.27s (×1.72)
0.31s (×1.94)
0.81s (×5.05)
0.74s (×4.60)
0.72s (×4.48)
0.38s (×2.40)
0.81s (×5.01)
0.58s (×3.60)
0.56s (×3.52)
0.62s (×3.85)
0.77s (×4.79)
0.77s (×4.79)
0.63s (×3.91)
0.30s (×1.93)
0.51s (×3.21)
0.67s (×4.15)
0.35s (×2.20)
0.62s (×3.89)
0.32s (×2.01)
0.36s (×2.26)
0.85s (×5.27)
0.67s (×4.16)
0.74s (×4.58)
0.40s (×2.52)
0.91s (×5.63)
0.90s (×5.56)
0.48s (×3.02)
0.51s (×3.19)
0.96s (×5.97)
0.32s (×2.03)
0.60s (×3.76)
1.57s (×9.71)
1.60s (×9.88)
0.63s (×3.91)
0.84s (×5.23)
0.94s (×5.84)
1.66s (×10.22)
0.97s (×5.99)
0.54s (×3.35)
1.12s (×6.95)
1.80s (×11.09)
1.62s (×9.98)
2.26s (×13.91)
1.54s (×9.50)
3.29s (×20.26)
0.76s (×4.75)
2.28s (×14.05)
1.06s (×6.59)
0.95s (×5.88)
2.08s (×12.82)
2.52s (×15.50)
2.16s (×13.31)
7.21s (×44.30)
4.60s (×28.29)
1.23s (×7.62)
8.32s (×51.10)
3.13s (×19.26)
2.39s (×14.71)
3.06s (×18.86)
3.28s (×20.17)
8.12s (×49.90)
9.87s (×60.61)
6.04s (×37.13)
3.86s (×23.74)
11.21s (×68.84)
5.60s (×34.40)
14.62s (×89.73)
59.25s (×363.56)
☠
☠
17.57s (×107.85)
86.28s (×529.39)
57.14s (×350.59)
2224.14s (×13645.09)
279.67s (×1715.85)
301.02s (×1846.82)
283.61s (×1740.01)
338.52s (×2076.87)
453.98s (×2785.21)
☠
Q15. Query 15: SELECT UserID, COUNT(*) FROM hits GROUP BY UserID ORDER BY COUNT(*) DESC LIMIT 10;
0.12s (×1.47)
0.08s (×1.00)
0.22s (×2.54)
0.14s (×1.69)
0.12s (×1.48)
0.16s (×1.89)
0.19s (×2.18)
0.14s (×1.70)
0.20s (×2.33)
0.36s (×4.11)
0.32s (×3.62)
0.59s (×6.68)
0.32s (×3.67)
0.31s (×3.56)
0.18s (×2.09)
0.53s (×5.98)
0.50s (×5.67)
0.62s (×6.97)
0.51s (×5.76)
0.37s (×4.22)
0.39s (×4.44)
0.50s (×5.64)
0.26s (×3.04)
0.23s (×2.69)
0.27s (×3.08)
0.30s (×3.47)
0.79s (×8.86)
0.28s (×3.26)
0.32s (×3.71)
0.44s (×5.02)
0.28s (×3.20)
0.87s (×9.77)
0.39s (×4.42)
0.39s (×4.46)
0.91s (×10.21)
0.40s (×4.59)
0.41s (×4.68)
0.38s (×4.32)
0.27s (×3.06)
0.53s (×6.03)
0.73s (×8.26)
1.55s (×17.33)
0.45s (×5.06)
0.84s (×9.50)
0.83s (×9.30)
0.67s (×7.54)
0.87s (×9.82)
1.13s (×12.64)
0.73s (×8.26)
1.03s (×11.58)
1.33s (×14.87)
1.12s (×12.53)
1.51s (×16.88)
3.46s (×38.61)
0.62s (×6.98)
2.28s (×25.44)
0.68s (×7.63)
0.89s (×10.03)
3.52s (×39.18)
2.55s (×28.49)
2.64s (×29.41)
2.37s (×26.42)
2.08s (×23.21)
1.12s (×12.60)
15.47s (×172.01)
5.03s (×55.97)
2.21s (×24.67)
7.99s (×88.91)
2.42s (×26.99)
9.04s (×100.53)
15.91s (×176.91)
3.10s (×34.59)
2.63s (×29.32)
19.11s (×212.42)
5.46s (×60.72)
26.34s (×292.72)
8.23s (×91.50)
☠
2.27s (×25.32)
53.57s (×595.38)
42.43s (×471.57)
420.00s (×4666.77)
30.69s (×341.11)
297.66s (×3307.43)
47.00s (×522.33)
32.02s (×355.92)
306.27s (×3403.11)
586.49s (×6516.67)
893.68s (×9929.89)
Q16. Query 16: SELECT UserID, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, SearchPhrase ORDER BY COUNT(*) DESC LIMIT 10;
0.32s (×1.08)
0.30s (×1.00)
0.48s (×1.58)
0.35s (×1.17)
0.35s (×1.15)
0.50s (×1.65)
0.66s (×2.15)
0.34s (×1.13)
0.64s (×2.09)
0.75s (×2.45)
0.54s (×1.79)
2.48s (×8.03)
0.98s (×3.19)
1.08s (×3.52)
0.69s (×2.25)
2.56s (×8.28)
1.66s (×5.39)
1.84s (×5.95)
1.64s (×5.31)
1.07s (×3.48)
1.49s (×4.84)
1.81s (×5.86)
0.39s (×1.28)
0.68s (×2.24)
1.19s (×3.87)
0.46s (×1.52)
1.60s (×5.20)
0.35s (×1.16)
0.39s (×1.30)
2.13s (×6.91)
1.00s (×3.26)
1.83s (×5.95)
0.64s (×2.09)
1.90s (×6.16)
2.60s (×8.40)
0.98s (×3.20)
1.10s (×3.59)
1.43s (×4.66)
0.59s (×1.94)
1.00s (×3.26)
2.76s (×8.94)
4.26s (×13.77)
0.91s (×2.97)
1.86s (×6.03)
2.15s (×6.95)
2.40s (×7.78)
1.78s (×5.77)
2.01s (×6.52)
2.26s (×7.31)
4.34s (×14.02)
4.12s (×13.31)
3.77s (×12.18)
2.99s (×9.68)
9.14s (×29.53)
1.22s (×3.96)
4.42s (×14.29)
2.06s (×6.69)
2.06s (×6.67)
6.11s (×19.73)
6.99s (×22.57)
5.67s (×18.31)
17.30s (×55.85)
8.17s (×26.39)
2.46s (×7.95)
19.69s (×63.56)
5.26s (×16.99)
3.70s (×11.96)
8.92s (×28.79)
2.15s (×6.98)
29.50s (×95.21)
20.77s (×67.02)
14.16s (×45.70)
☠
☠
12.75s (×41.15)
36.41s (×117.49)
☠
☠
☠
69.78s (×225.14)
111.81s (×360.70)
266.80s (×860.68)
16168.44s (×52156.29)
312.57s (×1008.32)
342.44s (×1104.68)
304.43s (×982.07)
740.75s (×2389.55)
856.36s (×2762.48)
☠
Q17. Query 17: SELECT UserID, SearchPhrase, COUNT(*) FROM hits GROUP BY UserID, SearchPhrase LIMIT 10;
0.10s (×1.00)
0.10s (×1.02)
0.46s (×4.33)
0.24s (×2.31)
0.26s (×2.54)
0.20s (×1.94)
0.37s (×3.51)
0.39s (×3.66)
0.36s (×3.43)
0.71s (×6.67)
0.52s (×4.95)
1.34s (×12.55)
0.22s (×2.13)
0.23s (×2.22)
0.51s (×4.85)
1.66s (×15.45)
0.68s (×6.35)
0.52s (×4.94)
0.85s (×8.01)
0.26s (×2.50)
0.51s (×4.81)
1.10s (×10.31)
0.43s (×4.11)
0.47s (×4.48)
0.92s (×8.58)
0.46s (×4.31)
1.53s (×14.28)
0.99s (×9.29)
0.53s (×5.04)
1.43s (×13.31)
0.72s (×6.73)
1.79s (×16.68)
0.57s (×5.36)
1.25s (×11.64)
1.71s (×15.94)
0.99s (×9.27)
1.34s (×12.47)
0.92s (×8.57)
0.48s (×4.53)
0.94s (×8.80)
2.09s (×19.45)
4.01s (×37.22)
0.85s (×7.94)
1.81s (×16.89)
1.97s (×18.32)
1.82s (×16.95)
1.53s (×14.22)
1.81s (×16.88)
2.40s (×22.35)
2.97s (×27.56)
3.94s (×36.57)
2.77s (×25.75)
2.55s (×23.69)
9.42s (×87.31)
1.05s (×9.84)
4.12s (×38.24)
1.34s (×12.55)
1.31s (×12.19)
4.35s (×40.34)
7.04s (×65.26)
3.88s (×36.01)
7.61s (×70.51)
6.22s (×57.73)
1.87s (×17.40)
19.28s (×178.64)
0.83s (×7.77)
2.27s (×21.15)
8.39s (×77.81)
2.82s (×26.22)
4.23s (×39.22)
20.28s (×187.88)
14.17s (×131.27)
☠
☠
12.17s (×112.75)
25.90s (×239.90)
☠
3.91s (×36.30)
☠
26.32s (×243.81)
87.79s (×812.96)
246.48s (×2282.35)
120.49s (×1115.74)
302.67s (×2802.61)
305.01s (×2824.23)
287.58s (×2662.85)
734.01s (×6796.48)
848.92s (×7860.46)
☠
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.77)
0.44s (×1.00)
0.63s (×1.43)
0.62s (×1.41)
0.68s (×1.54)
1.06s (×2.38)
1.14s (×2.56)
0.66s (×1.50)
1.15s (×2.58)
0.96s (×2.16)
1.00s (×2.25)
4.24s (×9.44)
1.80s (×4.02)
1.98s (×4.42)
1.29s (×2.89)
4.18s (×9.31)
3.12s (×6.96)
3.29s (×7.34)
3.22s (×7.17)
2.02s (×4.51)
2.56s (×5.71)
3.19s (×7.11)
0.51s (×1.15)
1.51s (×3.37)
2.14s (×4.78)
0.66s (×1.49)
3.07s (×6.83)
0.56s (×1.26)
0.82s (×1.85)
3.48s (×7.75)
1.93s (×4.30)
3.44s (×7.68)
0.90s (×2.02)
2.89s (×6.44)
4.69s (×10.45)
2.03s (×4.53)
1.97s (×4.39)
2.33s (×5.19)
1.03s (×2.30)
1.56s (×3.49)
5.11s (×11.39)
9.56s (×21.27)
1.70s (×3.80)
3.49s (×7.78)
4.95s (×11.03)
5.07s (×11.30)
2.82s (×6.28)
2.56s (×5.71)
3.47s (×7.73)
8.67s (×19.30)
7.22s (×16.07)
12.37s (×27.51)
5.77s (×12.84)
19.61s (×43.60)
1.97s (×4.40)
☠
4.57s (×10.18)
4.06s (×9.05)
11.07s (×24.62)
☠
9.84s (×21.90)
29.89s (×66.45)
25.35s (×56.35)
5.18s (×11.53)
30.21s (×67.15)
☠
2.97s (×6.62)
14.95s (×33.24)
3.58s (×7.98)
38.06s (×84.60)
38.38s (×85.32)
26.69s (×59.34)
☠
☠
36.49s (×81.12)
63.51s (×141.16)
☠
☠
☠
121.18s (×269.32)
161.39s (×358.68)
465.40s (×1034.24)
78504.89s (×174455.33)
324.06s (×720.16)
380.38s (×845.32)
327.49s (×727.77)
868.84s (×1930.78)
1011.16s (×2247.04)
1419.34s (×3154.11)
Q19. Query 19: SELECT UserID FROM hits WHERE UserID = 435090932899640449;
0.01s (×2.07)
0.00s (×0.94)
0.00s (×1.31)
0.01s (×2.07)
0.03s (×3.66)
0.00s (×0.94)
0.02s (×3.10)
0.03s (×3.71)
0.01s (×2.35)
0.01s (×1.88)
0.44s (×42.06)
0.00s (×1.24)
0.01s (×1.88)
0.01s (×1.88)
0.04s (×4.32)
0.00s (×1.27)
0.01s (×2.26)
0.01s (×2.16)
0.01s (×2.26)
0.01s (×1.88)
0.00s (×0.94)
0.02s (×2.44)
0.31s (×29.78)
0.05s (×5.73)
0.04s (×4.70)
0.16s (×15.60)
0.44s (×42.13)
0.28s (×27.06)
0.03s (×3.29)
0.02s (×3.10)
0.04s (×5.17)
0.53s (×50.47)
0.16s (×15.97)
0.05s (×5.73)
0.02s (×2.82)
0.09s (×9.15)
0.03s (×3.74)
0.04s (×4.70)
0.07s (×7.70)
0.18s (×18.23)
0.05s (×5.64)
0.05s (×5.64)
0.17s (×16.44)
0.60s (×57.58)
0.11s (×10.85)
0.05s (×5.36)
0.26s (×24.99)
0.10s (×10.23)
0.05s (×5.90)
0.05s (×5.45)
0.10s (×10.53)
0.07s (×7.14)
0.42s (×40.03)
0.00s (×1.00)
0.30s (×28.85)
0.04s (×4.70)
0.16s (×16.16)
0.20s (×19.66)
0.11s (×11.46)
0.10s (×10.79)
0.38s (×36.17)
0.09s (×9.68)
0.08s (×8.27)
0.69s (×65.49)
0.03s (×4.21)
0.01s (×2.35)
2.38s (×224.94)
0.93s (×88.75)
3.54s (×333.83)
0.09s (×9.83)
0.02s (×2.96)
0.37s (×35.42)
0.11s (×11.18)
0.01s (×1.46)
0.00s (×1.13)
0.54s (×51.33)
☠
0.08s (×8.74)
0.06s (×6.58)
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.26s (×3.35)
0.15s (×2.00)
0.09s (×1.21)
0.15s (×2.02)
0.33s (×4.30)
0.60s (×7.63)
0.32s (×4.16)
0.34s (×4.32)
0.38s (×4.84)
0.20s (×2.63)
0.14s (×1.84)
0.44s (×5.61)
1.04s (×13.13)
1.30s (×16.38)
1.43s (×18.02)
0.55s (×7.02)
0.76s (×9.56)
0.67s (×8.54)
0.70s (×8.88)
1.14s (×14.37)
1.10s (×13.88)
0.76s (×9.65)
0.28s (×3.63)
0.87s (×11.01)
0.80s (×10.15)
0.31s (×4.03)
0.82s (×10.32)
0.25s (×3.24)
0.24s (×3.07)
0.98s (×12.39)
1.07s (×13.50)
0.81s (×10.28)
0.44s (×5.65)
0.96s (×12.16)
1.39s (×17.44)
0.38s (×4.89)
1.52s (×19.07)
1.83s (×23.05)
1.25s (×15.81)
0.61s (×7.74)
1.71s (×21.44)
1.24s (×15.63)
0.85s (×10.72)
1.83s (×22.97)
0.74s (×9.36)
3.25s (×40.81)
0.99s (×12.54)
0.86s (×10.87)
2.50s (×31.35)
2.80s (×35.14)
0.82s (×10.32)
4.59s (×57.45)
1.61s (×20.24)
1.57s (×19.75)
1.11s (×14.05)
1.74s (×21.88)
1.96s (×24.68)
3.43s (×43.02)
1.59s (×20.05)
1.57s (×19.78)
3.06s (×38.38)
11.96s (×149.66)
10.62s (×132.90)
2.66s (×33.42)
2.65s (×33.24)
19.13s (×239.23)
3.17s (×39.80)
3.18s (×39.84)
2.81s (×35.21)
2.63s (×33.01)
6.19s (×77.50)
7.50s (×93.85)
6.07s (×75.99)
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.25s (×2.30)
0.12s (×1.15)
0.10s (×1.00)
0.16s (×1.50)
0.26s (×2.35)
0.34s (×3.09)
0.37s (×3.34)
0.36s (×3.30)
0.43s (×3.92)
0.14s (×1.32)
0.17s (×1.58)
0.53s (×4.78)
0.84s (×7.50)
0.99s (×8.82)
0.58s (×5.22)
0.68s (×6.06)
0.87s (×7.74)
0.74s (×6.61)
0.79s (×7.03)
0.94s (×8.38)
0.91s (×8.12)
0.85s (×7.56)
0.25s (×2.28)
0.95s (×8.51)
0.86s (×7.64)
0.29s (×2.66)
0.53s (×4.80)
0.29s (×2.68)
0.59s (×5.27)
1.08s (×9.58)
1.29s (×11.47)
0.60s (×5.42)
0.34s (×3.06)
1.10s (×9.76)
1.29s (×11.49)
0.36s (×3.29)
1.58s (×14.04)
1.99s (×17.63)
1.11s (×9.89)
0.52s (×4.71)
1.88s (×16.71)
0.55s (×4.94)
0.94s (×8.42)
1.71s (×15.17)
0.79s (×7.06)
3.76s (×33.24)
0.73s (×6.57)
0.97s (×8.61)
2.61s (×23.09)
3.35s (×29.68)
0.89s (×7.94)
5.46s (×48.21)
1.16s (×10.35)
0.40s (×3.58)
1.58s (×14.03)
0.98s (×8.73)
2.41s (×21.35)
3.83s (×33.83)
1.90s (×16.85)
1.63s (×14.50)
1.97s (×17.48)
7.01s (×61.96)
13.18s (×116.34)
3.11s (×27.56)
2.43s (×21.56)
☠
2.97s (×26.30)
3.52s (×31.13)
2.93s (×25.92)
2.83s (×25.04)
6.89s (×60.85)
9.60s (×84.80)
2.18s (×19.30)
0.79s (×7.06)
16.46s (×145.28)
9.02s (×79.64)
☠
☠
☠
29.30s (×258.53)
59.53s (×525.20)
20.13s (×177.66)
389.23s (×3433.66)
267.47s (×2359.53)
287.18s (×2533.45)
267.69s (×2361.50)
305.12s (×2691.69)
432.88s (×3818.72)
921.70s (×8130.82)
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 (×2.11)
0.24s (×1.16)
0.43s (×2.05)
0.37s (×1.77)
0.45s (×2.11)
0.37s (×1.76)
0.72s (×3.38)
1.03s (×4.82)
0.77s (×3.61)
0.31s (×1.48)
0.21s (×1.00)
1.01s (×4.71)
0.87s (×4.08)
1.04s (×4.87)
0.96s (×4.51)
1.27s (×5.92)
1.32s (×6.19)
1.52s (×7.09)
2.25s (×10.46)
0.98s (×4.59)
1.94s (×9.04)
1.68s (×7.83)
0.48s (×2.26)
1.45s (×6.79)
1.34s (×6.26)
0.42s (×1.99)
0.78s (×3.64)
0.48s (×2.26)
0.93s (×4.37)
1.95s (×9.07)
2.07s (×9.64)
0.89s (×4.19)
0.51s (×2.39)
1.75s (×8.16)
2.40s (×11.17)
0.61s (×2.87)
3.56s (×16.53)
3.12s (×14.53)
2.11s (×9.81)
0.83s (×3.88)
3.03s (×14.08)
0.89s (×4.17)
1.32s (×6.18)
3.60s (×16.73)
1.91s (×8.90)
6.18s (×28.71)
1.08s (×5.05)
2.51s (×11.68)
6.77s (×31.45)
5.69s (×26.43)
1.89s (×8.82)
8.88s (×41.24)
1.37s (×6.40)
0.40s (×1.88)
2.46s (×11.46)
1.22s (×5.70)
5.36s (×24.91)
6.95s (×32.28)
4.34s (×20.15)
3.66s (×17.00)
2.47s (×11.50)
11.59s (×53.76)
22.50s (×104.36)
6.73s (×31.24)
1.46s (×6.79)
14.23s (×66.01)
2.91s (×13.52)
4.86s (×22.59)
4.05s (×18.81)
3.47s (×16.14)
4.05s (×18.80)
17.48s (×81.10)
26.64s (×123.56)
1.70s (×7.91)
25.73s (×119.33)
13.84s (×64.23)
☠
☠
☠
37.70s (×174.84)
57.39s (×266.15)
23.20s (×107.62)
575.06s (×2666.26)
263.10s (×1219.87)
288.64s (×1338.29)
263.12s (×1219.98)
298.44s (×1383.73)
420.73s (×1950.72)
918.37s (×4257.98)
Q23. Query 23: SELECT * FROM hits WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 10;
0.72s (×12.83)
0.86s (×15.33)
0.23s (×4.27)
0.77s (×13.67)
1.15s (×20.38)
0.25s (×4.58)
1.11s (×19.77)
1.35s (×24.04)
1.27s (×22.52)
0.39s (×7.05)
1.34s (×23.76)
0.19s (×3.61)
0.29s (×5.29)
0.50s (×8.99)
2.32s (×41.12)
0.27s (×4.99)
1.22s (×21.67)
1.20s (×21.25)
2.91s (×51.44)
2.27s (×40.17)
1.22s (×21.67)
2.51s (×44.40)
0.49s (×8.84)
2.46s (×43.53)
2.95s (×52.15)
0.70s (×12.44)
4.10s (×72.45)
0.42s (×7.66)
0.91s (×16.26)
3.87s (×68.36)
4.33s (×76.53)
4.43s (×78.23)
0.96s (×17.07)
4.04s (×71.28)
4.24s (×74.91)
1.92s (×33.99)
4.89s (×86.25)
5.04s (×89.01)
5.87s (×103.62)
2.11s (×37.30)
6.34s (×111.82)
2.15s (×38.05)
4.26s (×75.23)
11.13s (×196.28)
5.96s (×105.20)
9.21s (×162.51)
2.64s (×46.72)
3.80s (×67.17)
9.55s (×168.47)
10.58s (×186.63)
6.81s (×120.17)
13.40s (×236.19)
4.14s (×73.10)
1.80s (×31.96)
6.77s (×119.41)
3.35s (×59.20)
17.56s (×309.58)
18.67s (×329.08)
12.13s (×213.85)
13.14s (×231.67)
9.52s (×167.86)
24.87s (×438.28)
46.55s (×820.21)
20.69s (×364.67)
0.05s (×1.00)
5.77s (×101.83)
7.60s (×134.02)
20.26s (×357.13)
6.12s (×108.05)
19.26s (×339.45)
6.24s (×110.06)
68.43s (×1205.72)
90.21s (×1589.46)
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.05s (×4.49)
0.02s (×2.41)
0.04s (×3.95)
0.05s (×4.98)
0.12s (×10.51)
0.04s (×4.01)
0.11s (×9.95)
0.09s (×8.30)
0.13s (×11.24)
0.08s (×7.22)
0.05s (×4.87)
0.03s (×3.02)
0.04s (×4.01)
0.04s (×4.01)
0.19s (×15.89)
0.03s (×3.07)
0.21s (×17.66)
0.16s (×13.48)
0.19s (×16.13)
0.13s (×11.24)
0.07s (×6.42)
0.22s (×18.14)
0.18s (×15.57)
0.46s (×37.40)
0.28s (×22.87)
0.20s (×16.77)
0.18s (×15.34)
0.18s (×15.57)
0.07s (×6.08)
0.34s (×28.41)
0.48s (×39.57)
0.23s (×19.03)
0.24s (×20.15)
0.33s (×27.21)
0.34s (×27.69)
0.17s (×14.17)
0.24s (×20.04)
0.50s (×40.77)
0.30s (×24.65)
0.43s (×34.99)
0.53s (×43.34)
0.20s (×16.85)
0.41s (×34.03)
0.48s (×39.06)
0.23s (×18.93)
1.26s (×101.93)
0.47s (×38.28)
0.25s (×20.71)
0.47s (×38.86)
0.81s (×65.49)
0.26s (×21.44)
1.68s (×135.64)
0.64s (×52.25)
0.16s (×13.36)
0.58s (×47.03)
0.32s (×26.49)
0.59s (×48.08)
0.82s (×66.51)
0.58s (×47.51)
0.48s (×39.62)
1.03s (×83.15)
1.78s (×143.35)
3.88s (×312.62)
1.10s (×89.33)
0.00s (×1.00)
0.29s (×23.76)
1.95s (×157.39)
1.66s (×134.13)
2.83s (×227.70)
0.99s (×80.61)
2.73s (×220.02)
3.42s (×275.46)
1.76s (×142.30)
0.15s (×12.75)
1.03s (×83.15)
3.17s (×254.89)
0.02s (×2.17)
0.26s (×21.51)
0.17s (×14.69)
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 (×3.75)
0.04s (×4.17)
0.04s (×4.47)
0.04s (×4.08)
0.08s (×7.75)
0.14s (×12.50)
0.08s (×7.75)
0.08s (×7.42)
0.09s (×8.50)
0.08s (×7.50)
0.13s (×11.48)
0.18s (×15.85)
0.12s (×10.83)
0.13s (×11.67)
0.14s (×12.42)
0.22s (×19.56)
0.16s (×14.08)
0.13s (×11.75)
0.15s (×13.00)
0.12s (×10.83)
0.12s (×10.83)
0.16s (×14.00)
0.17s (×14.92)
0.23s (×19.75)
0.23s (×19.67)
0.18s (×16.00)
0.18s (×16.04)
0.20s (×17.58)
0.07s (×6.30)
0.29s (×25.00)
0.26s (×22.83)
0.22s (×19.54)
0.24s (×20.75)
0.28s (×24.58)
0.26s (×22.50)
0.16s (×14.25)
0.23s (×20.12)
0.32s (×27.17)
0.31s (×26.78)
0.30s (×25.50)
0.43s (×36.33)
0.16s (×14.17)
0.36s (×30.67)
0.37s (×31.95)
0.17s (×14.64)
0.54s (×45.75)
0.38s (×32.67)
0.21s (×18.31)
0.46s (×38.75)
0.59s (×50.17)
0.25s (×21.91)
0.79s (×66.33)
0.51s (×43.25)
0.17s (×14.81)
0.41s (×35.42)
0.35s (×30.00)
0.44s (×37.25)
0.72s (×60.42)
0.47s (×40.42)
0.37s (×31.64)
0.85s (×71.33)
1.17s (×97.92)
1.82s (×152.58)
0.79s (×66.42)
2.06s (×172.65)
0.40s (×33.75)
2.72s (×227.33)
1.25s (×105.13)
2.57s (×214.75)
0.78s (×65.47)
2.96s (×247.17)
2.50s (×208.83)
1.75s (×146.58)
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.90)
0.02s (×1.00)
0.04s (×1.65)
0.05s (×2.03)
0.12s (×4.20)
0.04s (×1.67)
0.13s (×4.53)
0.08s (×3.04)
0.12s (×4.30)
0.07s (×2.67)
0.08s (×2.85)
0.03s (×1.25)
0.03s (×1.33)
0.04s (×1.67)
0.18s (×6.47)
0.03s (×1.25)
0.21s (×7.43)
0.16s (×5.53)
0.17s (×6.17)
0.14s (×5.00)
0.04s (×1.67)
0.21s (×7.47)
0.19s (×6.53)
0.42s (×14.23)
0.28s (×9.57)
0.20s (×6.83)
0.19s (×6.52)
0.40s (×13.73)
0.07s (×2.60)
0.34s (×11.50)
0.52s (×17.63)
0.23s (×8.02)
0.23s (×8.07)
0.35s (×11.90)
0.34s (×11.60)
0.18s (×6.28)
0.24s (×8.43)
0.58s (×19.80)
0.24s (×8.47)
0.31s (×10.80)
0.61s (×20.67)
0.16s (×5.67)
0.40s (×13.73)
0.49s (×16.52)
0.23s (×8.14)
1.06s (×35.77)
0.47s (×16.03)
0.22s (×7.54)
0.47s (×16.14)
0.85s (×28.53)
0.29s (×10.00)
1.53s (×51.47)
0.62s (×21.03)
0.17s (×6.04)
0.61s (×20.83)
0.32s (×11.00)
0.61s (×20.70)
0.76s (×25.75)
0.57s (×19.33)
0.50s (×17.14)
1.08s (×36.43)
1.78s (×59.60)
3.92s (×131.13)
1.05s (×35.20)
2.15s (×72.01)
0.50s (×16.97)
2.42s (×80.90)
1.47s (×49.20)
2.92s (×97.83)
1.00s (×33.62)
2.89s (×96.78)
3.45s (×115.37)
1.82s (×61.03)
0.14s (×5.00)
1.03s (×34.67)
3.14s (×104.97)
☠
☠
☠
10.41s (×347.25)
51.96s (×1732.27)
15.35s (×512.10)
40.11s (×1337.33)
0.34s (×11.63)
286.91s (×9564.00)
263.09s (×8769.93)
278.04s (×9268.33)
394.67s (×13156.00)
898.89s (×29963.33)
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 (×4.55)
0.21s (×2.23)
0.09s (×1.00)
0.30s (×3.13)
0.36s (×3.72)
0.54s (×5.57)
0.36s (×3.76)
0.30s (×3.09)
0.42s (×4.41)
0.13s (×1.42)
0.27s (×2.86)
0.40s (×4.13)
1.11s (×11.35)
1.16s (×11.85)
0.65s (×6.69)
0.50s (×5.19)
0.75s (×7.72)
0.79s (×8.10)
0.81s (×8.30)
1.18s (×12.06)
1.42s (×14.49)
0.77s (×7.88)
0.40s (×4.12)
0.91s (×9.31)
0.86s (×8.82)
0.33s (×3.44)
0.47s (×4.86)
0.32s (×3.36)
0.40s (×4.11)
1.06s (×10.85)
1.04s (×10.61)
0.53s (×5.48)
0.40s (×4.18)
1.04s (×10.66)
1.14s (×11.65)
0.39s (×4.08)
1.25s (×12.80)
1.82s (×18.58)
1.59s (×16.22)
0.64s (×6.55)
1.63s (×16.65)
0.56s (×5.77)
0.88s (×9.04)
1.47s (×15.02)
0.90s (×9.18)
3.30s (×33.51)
1.19s (×12.18)
0.79s (×8.06)
2.06s (×20.97)
2.88s (×29.25)
0.85s (×8.74)
4.77s (×48.40)
1.51s (×15.39)
3.11s (×31.64)
1.46s (×14.92)
1.15s (×11.75)
2.15s (×21.87)
4.06s (×41.19)
2.48s (×25.22)
1.58s (×16.13)
3.12s (×31.68)
6.19s (×62.77)
11.52s (×116.84)
2.72s (×27.70)
10.74s (×108.86)
2.38s (×24.19)
2.52s (×25.64)
6.02s (×61.12)
2.78s (×28.27)
4.13s (×41.91)
9.59s (×97.25)
7.48s (×75.84)
9.59s (×97.26)
19.69s (×199.54)
117.06s (×1186.03)
13.53s (×137.19)
29.22s (×296.15)
☠
☠
39.69s (×402.19)
59.22s (×600.05)
109.01s (×1104.46)
445.03s (×4508.74)
267.49s (×2710.08)
305.63s (×3096.43)
268.20s (×2717.30)
406.88s (×4122.24)
387.21s (×3922.96)
901.28s (×9131.06)
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.13s (×1.39)
0.23s (×2.33)
0.11s (×1.22)
0.14s (×1.49)
0.23s (×2.38)
0.20s (×2.05)
0.16s (×1.71)
0.21s (×2.18)
0.17s (×1.78)
0.24s (×2.43)
0.49s (×4.93)
0.37s (×3.76)
0.37s (×3.76)
0.30s (×3.05)
0.55s (×5.55)
0.38s (×3.81)
0.39s (×3.94)
0.45s (×4.53)
0.42s (×4.26)
0.36s (×3.66)
0.42s (×4.27)
0.37s (×3.80)
0.28s (×2.82)
0.49s (×4.95)
0.28s (×2.89)
0.57s (×5.77)
0.31s (×3.17)
0.33s (×3.34)
0.66s (×6.60)
0.44s (×4.45)
0.67s (×6.73)
0.36s (×3.69)
0.64s (×6.40)
0.66s (×6.63)
0.34s (×3.51)
0.40s (×4.11)
0.64s (×6.48)
0.32s (×3.26)
0.54s (×5.42)
1.17s (×11.68)
1.03s (×10.30)
0.58s (×5.80)
0.92s (×9.23)
0.66s (×6.61)
1.11s (×11.12)
0.83s (×8.32)
0.85s (×8.51)
0.85s (×8.47)
1.28s (×12.76)
1.07s (×10.66)
1.40s (×14.00)
1.22s (×12.22)
2.45s (×24.33)
0.74s (×7.42)
1.11s (×11.09)
0.94s (×9.41)
1.03s (×10.33)
2.94s (×29.21)
2.03s (×20.23)
2.02s (×20.07)
2.85s (×28.31)
3.33s (×33.07)
1.33s (×13.24)
19.85s (×196.63)
4.57s (×45.30)
2.34s (×23.24)
3.19s (×31.73)
2.95s (×29.34)
9.63s (×95.49)
21.03s (×208.36)
4.19s (×41.55)
2.65s (×26.38)
8.47s (×83.95)
2.15s (×21.44)
14.68s (×145.45)
19.24s (×190.57)
☠
1.11s (×11.13)
20.95s (×207.55)
64.28s (×636.50)
4873.49s (×48252.46)
58.07s (×575.05)
274.00s (×2712.92)
295.18s (×2922.68)
270.29s (×2676.28)
331.94s (×3286.63)
489.59s (×4847.52)
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.00)
0.18s (×1.12)
0.28s (×1.71)
0.16s (×1.03)
0.23s (×1.44)
0.20s (×1.24)
0.26s (×1.57)
0.20s (×1.27)
0.28s (×1.69)
0.29s (×1.78)
0.32s (×1.96)
0.97s (×5.83)
0.42s (×2.54)
0.41s (×2.49)
0.38s (×2.30)
0.87s (×5.19)
0.50s (×3.04)
0.60s (×3.59)
0.68s (×4.07)
0.50s (×3.02)
0.52s (×3.14)
0.51s (×3.08)
0.29s (×1.75)
0.35s (×2.14)
0.56s (×3.39)
0.40s (×2.45)
0.80s (×4.82)
0.36s (×2.21)
0.34s (×2.07)
0.90s (×5.40)
0.43s (×2.60)
0.94s (×5.63)
0.41s (×2.50)
0.88s (×5.25)
0.76s (×4.58)
0.55s (×3.30)
0.59s (×3.53)
0.75s (×4.47)
0.46s (×2.79)
0.66s (×3.96)
1.57s (×9.37)
1.45s (×8.64)
0.69s (×4.14)
1.14s (×6.82)
1.11s (×6.66)
1.23s (×7.32)
1.06s (×6.34)
0.53s (×3.21)
1.07s (×6.39)
1.72s (×10.25)
1.63s (×9.73)
1.94s (×11.51)
1.50s (×8.92)
3.47s (×20.57)
1.18s (×7.07)
1.70s (×10.12)
1.38s (×8.21)
1.42s (×8.46)
4.40s (×26.08)
3.41s (×20.24)
2.56s (×15.24)
4.00s (×23.75)
4.50s (×26.66)
2.35s (×13.93)
43.87s (×259.66)
5.01s (×29.69)
3.59s (×21.31)
4.00s (×23.75)
3.16s (×18.75)
17.62s (×104.34)
62.12s (×367.61)
5.48s (×32.49)
3.68s (×21.82)
16.06s (×95.06)
2.23s (×13.27)
22.13s (×131.01)
52.45s (×310.42)
☠
2.75s (×16.35)
25.63s (×151.74)
68.95s (×408.07)
4748.19s (×28095.89)
78.92s (×467.04)
281.39s (×1665.09)
298.19s (×1764.50)
275.93s (×1632.75)
500.53s (×2961.78)
647.32s (×3830.36)
921.10s (×5450.36)
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.86s (×1.69)
0.91s (×1.79)
0.90s (×1.77)
0.93s (×1.82)
1.53s (×2.99)
1.63s (×3.19)
0.66s (×1.30)
1.57s (×3.06)
1.04s (×2.04)
1.68s (×3.28)
5.49s (×10.68)
2.76s (×5.38)
2.75s (×5.36)
1.55s (×3.03)
4.60s (×8.96)
2.88s (×5.61)
4.11s (×7.99)
4.01s (×7.80)
3.16s (×6.16)
3.48s (×6.78)
2.89s (×5.63)
0.51s (×1.00)
1.70s (×3.33)
1.88s (×3.67)
0.75s (×1.48)
4.72s (×9.19)
0.78s (×1.54)
0.74s (×1.46)
3.65s (×7.10)
2.31s (×4.50)
4.95s (×9.63)
1.08s (×2.13)
2.96s (×5.77)
4.82s (×9.38)
2.77s (×5.41)
1.69s (×3.29)
2.33s (×4.54)
1.51s (×2.95)
1.68s (×3.28)
5.99s (×11.64)
10.42s (×20.25)
1.72s (×3.37)
5.28s (×10.28)
6.49s (×12.63)
4.33s (×8.43)
3.62s (×7.05)
2.44s (×4.75)
3.87s (×7.53)
15.08s (×29.30)
11.25s (×21.87)
12.42s (×24.14)
5.75s (×11.19)
22.57s (×43.84)
2.22s (×4.33)
☠
4.92s (×9.57)
5.91s (×11.49)
☠
19.81s (×38.49)
9.56s (×18.58)
33.35s (×64.78)
25.59s (×49.70)
5.68s (×11.05)
43.52s (×84.52)
5.01s (×9.74)
3.15s (×6.14)
40.11s (×77.90)
4.23s (×8.24)
145.75s (×283.04)
60.83s (×118.14)
20.75s (×40.32)
☠
☠
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.62s (×1.26)
0.96s (×1.92)
0.68s (×1.38)
0.67s (×1.35)
0.80s (×1.61)
1.67s (×3.33)
1.10s (×2.21)
0.92s (×1.84)
1.19s (×2.38)
1.41s (×2.82)
1.21s (×2.41)
3.43s (×6.82)
4.04s (×8.04)
3.95s (×7.86)
1.28s (×2.56)
2.96s (×5.90)
2.64s (×5.26)
3.25s (×6.47)
3.18s (×6.33)
4.40s (×8.75)
6.08s (×12.08)
2.65s (×5.28)
0.60s (×1.21)
1.65s (×3.30)
1.85s (×3.69)
0.83s (×1.68)
2.20s (×4.39)
0.71s (×1.43)
0.78s (×1.58)
2.81s (×5.60)
2.24s (×4.46)
2.34s (×4.65)
1.27s (×2.54)
2.49s (×4.96)
4.09s (×8.14)
1.96s (×3.92)
2.82s (×5.62)
2.99s (×5.95)
1.67s (×3.33)
2.13s (×4.25)
4.76s (×9.47)
9.61s (×19.09)
1.60s (×3.19)
3.15s (×6.28)
4.53s (×9.01)
5.05s (×10.04)
3.66s (×7.29)
3.52s (×7.01)
5.26s (×10.46)
7.44s (×14.79)
6.42s (×12.76)
7.18s (×14.28)
6.71s (×13.34)
18.89s (×37.50)
1.86s (×3.70)
☠
4.76s (×9.46)
5.13s (×10.19)
8.70s (×17.27)
10.16s (×20.18)
9.37s (×18.61)
28.98s (×57.53)
31.71s (×62.94)
5.28s (×10.49)
37.64s (×74.70)
5.11s (×10.15)
3.19s (×6.34)
12.89s (×25.59)
3.11s (×6.18)
24.64s (×48.90)
47.26s (×93.79)
19.76s (×39.23)
☠
☠
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.60s (×1.11)
0.97s (×1.77)
0.68s (×1.25)
0.69s (×1.26)
0.83s (×1.52)
1.75s (×3.18)
1.04s (×1.90)
0.94s (×1.71)
1.26s (×2.29)
1.40s (×2.55)
1.04s (×1.90)
3.47s (×6.27)
4.05s (×7.33)
4.03s (×7.29)
1.36s (×2.48)
2.95s (×5.34)
2.61s (×4.74)
3.15s (×5.70)
3.19s (×5.77)
4.27s (×7.73)
6.31s (×11.41)
2.66s (×4.82)
0.61s (×1.12)
1.71s (×3.10)
1.87s (×3.39)
0.82s (×1.50)
2.23s (×4.04)
0.54s (×1.00)
1.05s (×1.91)
2.78s (×5.04)
2.16s (×3.91)
2.39s (×4.34)
1.24s (×2.26)
2.56s (×4.65)
4.11s (×7.44)
1.91s (×3.46)
2.84s (×5.14)
2.99s (×5.41)
1.65s (×3.00)
2.11s (×3.83)
4.95s (×8.95)
9.84s (×17.78)
1.58s (×2.86)
3.19s (×5.77)
4.50s (×8.14)
5.06s (×9.15)
3.61s (×6.54)
3.53s (×6.40)
5.16s (×9.34)
7.39s (×13.35)
6.38s (×11.54)
7.06s (×12.77)
6.68s (×12.07)
19.05s (×34.40)
2.06s (×3.73)
☠
4.77s (×8.63)
5.40s (×9.77)
9.20s (×16.62)
10.11s (×18.27)
9.19s (×16.60)
27.57s (×49.78)
24.77s (×44.73)
5.38s (×9.73)
38.41s (×69.35)
6.24s (×11.28)
2.69s (×4.88)
13.54s (×24.46)
2.79s (×5.05)
27.46s (×49.58)
46.16s (×83.34)
19.46s (×35.14)
☠
☠
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.58)
0.12s (×1.00)
0.26s (×2.09)
0.19s (×1.56)
0.18s (×1.49)
0.20s (×1.62)
0.34s (×2.72)
0.14s (×1.14)
0.37s (×2.92)
0.45s (×3.54)
0.30s (×2.42)
0.54s (×4.25)
0.41s (×3.23)
0.39s (×3.08)
0.34s (×2.68)
0.49s (×3.86)
0.92s (×7.18)
0.84s (×6.56)
0.82s (×6.37)
1.11s (×8.62)
0.51s (×4.00)
0.92s (×7.12)
0.30s (×2.37)
0.48s (×3.80)
0.49s (×3.84)
0.36s (×2.85)
0.82s (×6.38)
0.34s (×2.68)
0.33s (×2.58)
0.94s (×7.30)
0.43s (×3.38)
0.93s (×7.20)
0.39s (×3.10)
0.77s (×5.98)
1.19s (×9.22)
0.64s (×4.99)
0.31s (×2.49)
0.68s (×5.27)
0.35s (×2.73)
0.62s (×4.84)
1.32s (×10.24)
1.79s (×13.85)
0.62s (×4.83)
0.88s (×6.84)
1.31s (×10.18)
1.17s (×9.11)
1.05s (×8.19)
0.87s (×6.78)
0.65s (×5.05)
2.12s (×16.35)
1.59s (×12.32)
1.87s (×14.43)
1.68s (×12.97)
12.98s (×99.95)
0.80s (×6.22)
1.84s (×14.23)
1.09s (×8.50)
1.10s (×8.57)
3.51s (×27.11)
3.39s (×26.17)
2.69s (×20.73)
4.54s (×34.96)
4.42s (×34.12)
1.47s (×11.36)
17.91s (×137.83)
5.93s (×45.72)
1.81s (×14.04)
9.90s (×76.23)
1.63s (×12.61)
8.52s (×65.61)
18.68s (×143.79)
5.83s (×44.89)
3.55s (×27.35)
44.44s (×341.91)
46.44s (×357.30)
28.03s (×215.72)
60.05s (×462.04)
☠
☠
60.19s (×463.04)
103.47s (×795.98)
419.33s (×3225.72)
66.93s (×514.92)
296.94s (×2284.21)
346.73s (×2667.22)
295.14s (×2270.38)
608.51s (×4680.92)
708.75s (×5452.00)
937.23s (×7209.54)
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.94)
0.06s (×1.77)
0.08s (×2.37)
0.06s (×1.64)
0.08s (×2.25)
0.04s (×1.26)
0.10s (×2.85)
0.30s (×7.84)
0.09s (×2.45)
0.12s (×3.28)
0.22s (×5.77)
0.06s (×1.65)
0.05s (×1.51)
0.06s (×1.77)
0.14s (×3.71)
0.06s (×1.82)
0.09s (×2.60)
0.14s (×3.66)
0.07s (×1.99)
0.05s (×1.51)
0.08s (×2.27)
0.09s (×2.62)
0.21s (×5.60)
0.13s (×3.41)
0.16s (×4.21)
0.19s (×4.95)
0.03s (×1.00)
0.22s (×5.83)
0.55s (×14.21)
0.09s (×2.55)
0.10s (×2.73)
0.03s (×1.09)
0.19s (×5.05)
0.12s (×3.26)
0.07s (×1.99)
0.28s (×7.20)
0.96s (×24.39)
0.11s (×3.05)
1.14s (×29.12)
0.20s (×5.17)
0.14s (×3.84)
0.14s (×3.79)
0.88s (×22.51)
0.18s (×4.81)
0.28s (×7.29)
0.10s (×2.75)
0.20s (×5.20)
0.96s (×24.45)
1.88s (×47.71)
0.12s (×3.31)
0.26s (×6.79)
0.10s (×2.65)
0.22s (×5.75)
0.32s (×8.38)
2.29s (×58.14)
0.19s (×5.05)
2.16s (×54.86)
3.50s (×88.64)
0.41s (×10.50)
0.23s (×6.12)
0.25s (×6.54)
0.16s (×4.21)
0.13s (×3.58)
3.73s (×94.36)
0.54s (×13.90)
0.20s (×5.35)
2.05s (×52.06)
0.17s (×4.53)
1.96s (×49.77)
0.86s (×21.92)
0.80s (×20.42)
7.21s (×182.33)
1.79s (×45.35)
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.89)
0.04s (×2.15)
0.02s (×1.38)
0.03s (×1.68)
0.04s (×2.15)
0.03s (×1.72)
0.05s (×2.41)
0.31s (×13.98)
0.05s (×2.41)
0.09s (×4.30)
0.21s (×9.36)
0.02s (×1.43)
0.03s (×1.72)
0.03s (×1.72)
0.07s (×3.66)
0.03s (×1.77)
0.04s (×2.28)
0.05s (×2.62)
0.03s (×1.76)
0.02s (×1.29)
0.05s (×2.58)
0.04s (×2.15)
0.14s (×6.41)
0.06s (×3.14)
0.06s (×2.80)
0.14s (×6.33)
0.01s (×1.00)
0.14s (×6.41)
0.59s (×25.74)
0.04s (×2.02)
0.06s (×2.97)
0.02s (×1.11)
0.14s (×6.45)
0.06s (×3.10)
0.03s (×1.68)
0.20s (×9.23)
1.10s (×47.91)
0.04s (×2.37)
1.09s (×47.17)
0.15s (×6.97)
0.06s (×3.18)
0.09s (×4.30)
0.69s (×30.25)
0.14s (×6.37)
0.16s (×7.27)
0.06s (×2.80)
0.14s (×6.41)
1.01s (×43.96)
2.17s (×93.90)
0.06s (×3.18)
0.20s (×9.07)
0.05s (×2.45)
0.13s (×6.20)
0.18s (×8.00)
1.80s (×77.93)
0.08s (×3.87)
2.11s (×91.10)
3.46s (×149.41)
0.21s (×9.64)
0.18s (×8.02)
0.14s (×6.67)
0.05s (×2.62)
0.08s (×4.00)
2.84s (×122.47)
0.33s (×14.73)
0.07s (×3.40)
1.52s (×66.01)
0.12s (×5.40)
2.15s (×93.12)
0.45s (×19.89)
0.74s (×32.31)
8.15s (×351.23)
0.91s (×39.42)
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.83)
0.03s (×1.70)
0.01s (×1.00)
0.03s (×1.49)
0.03s (×1.88)
0.02s (×1.28)
0.04s (×2.17)
0.07s (×3.22)
0.04s (×2.22)
0.11s (×5.11)
0.33s (×14.31)
0.01s (×1.05)
0.02s (×1.28)
0.02s (×1.28)
0.07s (×3.37)
0.02s (×1.11)
0.04s (×2.13)
0.04s (×2.13)
0.03s (×1.49)
0.02s (×1.28)
0.04s (×2.13)
0.04s (×1.96)
0.15s (×6.86)
0.07s (×3.41)
0.07s (×3.20)
0.13s (×6.05)
0.02s (×1.21)
0.14s (×6.22)
0.42s (×18.48)
0.03s (×1.75)
0.05s (×2.69)
0.02s (×1.21)
0.14s (×6.44)
0.06s (×2.98)
0.03s (×1.70)
0.19s (×8.53)
0.11s (×4.99)
0.06s (×2.90)
1.10s (×47.21)
0.14s (×6.22)
0.05s (×2.64)
0.08s (×3.84)
0.83s (×36.02)
0.14s (×6.21)
0.14s (×6.40)
0.05s (×2.56)
0.14s (×6.56)
0.37s (×16.18)
0.23s (×10.15)
0.07s (×3.45)
0.16s (×7.10)
0.07s (×3.32)
0.16s (×7.08)
0.16s (×7.22)
1.98s (×84.61)
0.05s (×2.56)
2.24s (×95.95)
3.52s (×150.64)
0.19s (×8.70)
0.15s (×6.69)
0.15s (×6.65)
0.07s (×3.24)
0.07s (×3.45)
3.27s (×139.89)
0.08s (×3.87)
0.03s (×1.88)
1.80s (×77.36)
0.10s (×4.57)
2.48s (×106.01)
0.12s (×5.41)
0.65s (×28.11)
7.19s (×306.89)
0.09s (×4.31)
0.05s (×2.75)
9.96s (×425.00)
0.14s (×6.25)
0.29s (×12.68)
0.26s (×11.34)
☠
0.80s (×34.54)
0.31s (×13.50)
2.22s (×95.14)
0.18s (×8.10)
0.90s (×38.87)
0.24s (×10.57)
0.42s (×18.16)
1.45s (×62.23)
0.96s (×41.35)
1.52s (×65.21)
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.49)
0.09s (×1.64)
0.06s (×1.12)
0.12s (×2.15)
0.18s (×3.17)
0.06s (×1.15)
0.21s (×3.58)
0.10s (×1.82)
0.19s (×3.26)
0.22s (×3.77)
0.19s (×3.36)
0.08s (×1.52)
0.12s (×2.13)
0.10s (×1.80)
0.26s (×4.49)
0.09s (×1.70)
0.20s (×3.49)
0.16s (×2.76)
0.14s (×2.53)
0.12s (×2.13)
0.18s (×3.12)
0.18s (×3.15)
0.30s (×5.02)
0.18s (×3.13)
0.26s (×4.44)
0.30s (×5.10)
0.05s (×1.00)
0.35s (×5.87)
0.49s (×8.28)
0.18s (×3.10)
0.17s (×2.87)
0.06s (×1.15)
0.29s (×4.94)
0.25s (×4.28)
0.15s (×2.64)
0.39s (×6.58)
0.15s (×2.61)
0.17s (×3.03)
1.72s (×28.42)
0.29s (×4.92)
0.27s (×4.59)
0.28s (×4.76)
1.07s (×17.78)
0.32s (×5.34)
0.43s (×7.29)
0.17s (×2.92)
0.29s (×4.87)
0.46s (×7.70)
0.28s (×4.68)
0.28s (×4.84)
0.45s (×7.55)
0.17s (×2.90)
0.32s (×5.40)
0.56s (×9.36)
1.69s (×27.92)
0.36s (×6.07)
4.28s (×70.28)
5.87s (×96.46)
0.77s (×12.83)
0.42s (×7.05)
0.36s (×6.00)
0.40s (×6.68)
0.30s (×5.13)
5.69s (×93.46)
0.69s (×11.46)
0.65s (×10.84)
2.79s (×45.97)
0.27s (×4.51)
3.58s (×58.95)
1.81s (×29.88)
0.94s (×15.52)
13.50s (×221.61)
1.13s (×18.75)
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.50)
0.03s (×2.07)
0.01s (×1.28)
0.02s (×1.60)
0.02s (×1.70)
0.02s (×1.55)
0.02s (×1.70)
0.05s (×2.93)
0.03s (×2.01)
0.07s (×4.13)
0.15s (×8.43)
0.01s (×1.23)
0.01s (×1.03)
0.02s (×1.55)
0.04s (×2.68)
0.02s (×1.50)
0.02s (×1.50)
0.01s (×1.29)
0.01s (×1.29)
0.02s (×1.55)
0.03s (×2.07)
0.02s (×1.50)
0.14s (×7.95)
0.03s (×2.01)
0.04s (×2.32)
0.17s (×9.29)
0.01s (×1.00)
0.13s (×7.33)
0.50s (×26.42)
0.02s (×1.39)
0.03s (×1.96)
0.01s (×1.01)
0.14s (×7.64)
0.03s (×2.01)
0.02s (×1.39)
0.14s (×7.67)
0.04s (×2.74)
0.03s (×2.12)
0.21s (×11.39)
0.13s (×7.18)
0.03s (×1.96)
0.02s (×1.55)
0.34s (×18.33)
0.08s (×4.68)
0.15s (×8.04)
0.03s (×1.81)
0.12s (×6.66)
0.14s (×7.60)
0.08s (×4.51)
0.03s (×2.01)
0.14s (×7.64)
0.02s (×1.60)
0.13s (×7.38)
0.10s (×5.82)
1.39s (×72.28)
0.03s (×2.07)
0.46s (×24.01)
0.70s (×36.43)
0.11s (×5.99)
0.18s (×9.85)
0.13s (×7.38)
0.03s (×1.96)
0.02s (×1.76)
1.33s (×69.23)
0.15s (×8.24)
0.07s (×4.18)
2.08s (×108.00)
0.11s (×5.95)
2.61s (×135.41)
0.12s (×6.51)
0.67s (×35.07)
1.50s (×77.75)
0.06s (×3.72)
0.13s (×7.46)
0.14s (×7.95)
0.14s (×7.65)
0.36s (×19.05)
0.11s (×6.30)
0.06s (×3.36)
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.03s (×2.14)
0.02s (×1.38)
0.02s (×1.66)
0.02s (×1.50)
0.02s (×1.61)
0.02s (×1.61)
0.05s (×3.07)
0.01s (×1.28)
0.16s (×9.10)
0.17s (×9.48)
0.01s (×1.01)
0.02s (×1.61)
0.02s (×1.61)
0.03s (×1.98)
0.01s (×1.12)
0.01s (×1.23)
0.01s (×1.23)
0.01s (×1.12)
0.02s (×1.61)
0.03s (×2.14)
0.01s (×1.23)
0.12s (×7.01)
0.03s (×1.98)
0.04s (×2.41)
0.17s (×9.85)
0.01s (×1.00)
0.12s (×7.17)
0.23s (×12.93)
0.01s (×1.12)
0.02s (×1.82)
0.01s (×1.01)
0.15s (×8.56)
0.02s (×1.82)
0.01s (×1.18)
0.13s (×7.62)
0.04s (×2.79)
0.02s (×1.55)
0.23s (×12.65)
0.13s (×7.38)
0.02s (×1.44)
0.01s (×1.07)
0.40s (×21.78)
0.08s (×5.01)
0.12s (×6.95)
0.02s (×1.66)
0.14s (×7.87)
0.13s (×7.49)
0.08s (×4.57)
0.03s (×1.87)
0.13s (×7.34)
0.02s (×1.61)
0.12s (×6.96)
0.15s (×8.76)
1.51s (×81.12)
0.02s (×1.61)
0.46s (×25.04)
0.66s (×35.63)
0.09s (×5.51)
0.12s (×7.03)
0.14s (×7.76)
0.02s (×1.66)
0.02s (×1.44)
1.90s (×102.15)
0.07s (×4.39)
0.04s (×2.51)
1.95s (×104.66)
0.12s (×6.81)
1.82s (×97.92)
0.11s (×6.32)
0.65s (×35.29)
1.38s (×74.38)
0.06s (×3.80)
0.06s (×3.54)
0.13s (×7.54)
0.12s (×7.12)
0.30s (×16.42)
0.12s (×6.74)
0.05s (×3.42)
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;