Q1. Query 1: SELECT COUNT(*)
FROM hits
WHERE AdvEngineID <> 0;
0.05s (×1.00)
0.17s (×3.20)
0.25s (×4.63)
0.29s (×5.32)
0.10s (×2.00)
Q2. Query 2: SELECT SUM(AdvEngineID),
COUNT(*),
AVG(ResolutionWidth)
FROM hits;
0.07s (×1.00)
0.18s (×2.42)
0.20s (×2.76)
0.24s (×3.17)
0.11s (×1.59)
Q3. Query 3: SELECT AVG(UserID)
FROM hits;
0.05s (×1.00)
0.29s (×4.78)
0.19s (×3.24)
0.20s (×3.38)
0.29s (×4.79)
Q4. Query 4: SELECT COUNT(DISTINCT UserID)
FROM hits;
0.31s (×1.00)
0.48s (×1.50)
0.35s (×1.12)
1.28s (×3.98)
3.18s (×9.85)
Q5. Query 5: SELECT COUNT(DISTINCT SearchPhrase)
FROM hits;
0.67s (×1.07)
0.73s (×1.17)
0.63s (×1.00)
1.64s (×2.59)
3.58s (×5.66)
Q6. Query 6: SELECT MIN(EventDate),
MAX(EventDate)
FROM hits;
0.05s (×4.36)
0.01s (×1.07)
0.01s (×1.07)
0.01s (×1.29)
0.00s (×1.00)
Q7. Query 7: SELECT AdvEngineID,
COUNT(*)
FROM hits
WHERE AdvEngineID <> 0
GROUP BY AdvEngineID
ORDER BY COUNT(*) DESC;
0.05s (×1.00)
0.13s (×2.44)
0.19s (×3.39)
0.26s (×4.58)
0.23s (×4.08)
Q8. Query 8: SELECT RegionID,
COUNT(DISTINCT UserID) AS u
FROM hits
GROUP BY RegionID
ORDER BY u DESC
LIMIT 10;
0.57s (×1.00)
0.64s (×1.12)
0.63s (×1.11)
1.81s (×3.15)
3.57s (×6.20)
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.65s (×1.00)
0.66s (×1.01)
0.83s (×1.28)
2.03s (×3.10)
3.64s (×5.54)
Q10. Query 10: SELECT MobilePhoneModel,
COUNT(DISTINCT UserID) AS u
FROM hits
WHERE MobilePhoneModel <> ''
GROUP BY MobilePhoneModel
ORDER BY u DESC
LIMIT 10;
0.35s (×1.07)
0.47s (×1.46)
0.32s (×1.00)
0.92s (×2.79)
1.25s (×3.79)
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.36s (×1.06)
0.49s (×1.45)
0.34s (×1.00)
1.07s (×3.13)
1.66s (×4.82)
Q12. Query 12: SELECT SearchPhrase,
COUNT(*) AS c
FROM hits
WHERE SearchPhrase <> ''
GROUP BY SearchPhrase
ORDER BY c DESC
LIMIT 10;
0.81s (×1.34)
0.75s (×1.24)
0.60s (×1.00)
1.63s (×2.66)
3.67s (×5.99)
Q13. Query 13: SELECT SearchPhrase,
COUNT(DISTINCT UserID) AS u
FROM hits
WHERE SearchPhrase <> ''
GROUP BY SearchPhrase
ORDER BY u DESC
LIMIT 10;
1.34s (×1.58)
0.85s (×1.00)
0.98s (×1.15)
1.96s (×2.29)
3.74s (×4.37)
Q14. Query 14: SELECT SearchEngineID,
SearchPhrase,
COUNT(*) AS c
FROM hits
WHERE SearchPhrase <> ''
GROUP BY SearchEngineID,
SearchPhrase
ORDER BY c DESC
LIMIT 10;
0.95s (×1.45)
0.76s (×1.17)
0.65s (×1.00)
1.69s (×2.57)
3.72s (×5.66)
Q15. Query 15: SELECT UserID,
COUNT(*)
FROM hits
GROUP BY UserID
ORDER BY COUNT(*) DESC
LIMIT 10;
0.70s (×1.46)
0.57s (×1.20)
0.48s (×1.00)
1.43s (×2.94)
3.38s (×6.94)
Q16. Query 16: SELECT UserID,
SearchPhrase,
COUNT(*)
FROM hits
GROUP BY UserID,
SearchPhrase
ORDER BY COUNT(*) DESC
LIMIT 10;
2.60s (×2.55)
1.01s (×1.00)
1.17s (×1.15)
2.13s (×2.08)
4.02s (×3.93)
Q17. Query 17: SELECT UserID,
SearchPhrase,
COUNT(*)
FROM hits
GROUP BY UserID,
SearchPhrase
LIMIT 10;
1.26s (×3.11)
0.40s (×1.00)
0.68s (×1.68)
0.74s (×1.84)
0.58s (×1.45)
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;
4.81s (×2.92)
1.64s (×1.00)
2.18s (×1.33)
3.13s (×1.90)
4.81s (×2.92)
Q19. Query 19: SELECT UserID
FROM hits
WHERE UserID = 435090932899640449;
0.01s (×1.00)
0.05s (×3.35)
0.03s (×2.59)
0.03s (×2.59)
0.06s (×3.88)
Q20. Query 20: SELECT COUNT(*)
FROM hits
WHERE URL LIKE '%google%';
0.51s (×1.00)
0.78s (×1.51)
1.61s (×3.09)
1.62s (×3.10)
0.78s (×1.51)
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.70s (×1.00)
0.83s (×1.19)
1.50s (×2.14)
1.53s (×2.18)
0.93s (×1.33)
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;
1.12s (×1.00)
1.73s (×1.53)
2.90s (×2.56)
3.79s (×3.35)
2.24s (×1.98)
Q23. Query 23: SELECT *
FROM hits
WHERE URL LIKE '%google%'
ORDER BY EventTime
LIMIT 10;
0.66s (×1.00)
1.14s (×1.71)
2.17s (×3.24)
2.17s (×3.24)
1.15s (×1.72)
Q24. Query 24: SELECT SearchPhrase
FROM hits
WHERE SearchPhrase <> ''
ORDER BY EventTime
LIMIT 10;
0.08s (×1.00)
0.72s (×8.51)
0.65s (×7.64)
0.62s (×7.30)
0.38s (×4.52)
Q25. Query 25: SELECT SearchPhrase
FROM hits
WHERE SearchPhrase <> ''
ORDER BY SearchPhrase
LIMIT 10;
0.57s (×1.96)
0.33s (×1.13)
0.29s (×1.00)
0.30s (×1.05)
0.34s (×1.20)
Q26. Query 26: SELECT SearchPhrase
FROM hits
WHERE SearchPhrase <> ''
ORDER BY EventTime,
SearchPhrase
LIMIT 10;
0.08s (×1.00)
0.39s (×4.47)
0.63s (×7.17)
0.61s (×6.96)
0.37s (×4.30)
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.74s (×1.00)
0.81s (×1.09)
1.49s (×1.99)
1.56s (×2.09)
0.83s (×1.12)
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.67s (×1.00)
0.74s (×1.10)
0.74s (×1.10)
1.92s (×2.85)
3.58s (×5.30)
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;
1.21s (×1.06)
1.15s (×1.01)
1.14s (×1.00)
2.15s (×1.88)
4.00s (×3.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;
6.77s (×3.64)
1.85s (×1.00)
3.03s (×1.63)
4.13s (×2.22)
5.13s (×2.76)
Q33. Query 33: SELECT URL,
COUNT(*) AS c
FROM hits
GROUP BY URL
ORDER BY c DESC
LIMIT 10;
3.57s (×1.98)
1.79s (×1.00)
2.56s (×1.42)
3.55s (×1.97)
5.26s (×2.92)
Q34. Query 34: SELECT 1,
URL,
COUNT(*) AS c
FROM hits
GROUP BY 1,
URL
ORDER BY c DESC
LIMIT 10;
3.56s (×1.98)
1.79s (×1.00)
2.52s (×1.40)
3.53s (×1.96)
5.44s (×3.02)
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.58s (×1.12)
0.57s (×1.10)
0.52s (×1.00)
1.53s (×2.91)
3.40s (×6.47)
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.12s (×1.00)
0.32s (×2.59)
0.35s (×2.81)
0.42s (×3.36)
0.52s (×4.20)
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.08s (×1.00)
0.34s (×3.98)
0.35s (×4.16)
0.42s (×4.99)
0.51s (×5.98)
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.00)
0.32s (×8.76)
0.31s (×8.39)
0.38s (×10.32)
0.50s (×13.53)
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.10s (×1.00)
0.40s (×3.84)
0.52s (×4.96)
0.55s (×5.27)
0.59s (×5.61)
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.03s (×1.00)
0.16s (×3.89)
0.30s (×7.14)
0.36s (×8.39)
0.49s (×11.32)
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.03s (×1.00)
0.14s (×3.89)
0.27s (×7.47)
0.36s (×9.66)
0.31s (×8.37)
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;