Page MenuHomePhabricator
Paste P12119

(An Untitled Masterwork)
ActivePublic

Authored by Addshore on Jul 29 2020, 10:11 AM.
Tags
None
Referenced Files
F31952978: raw.txt
Jul 29 2020, 10:11 AM
Subscribers
None
SELECT
COUNT(*) AS count,
AVG(query_time) AS avgQueryTime,
reflect("java.net.URLEncoder", "encode",query) AS urlEncodedQuery
FROM event.wdqs_external_sparql_query
WHERE year = 2020
AND month = 07
AND day = 22
AND namespace = "wdq"
GROUP BY query
ORDER BY count DESC
LIMIT 1000000
SELECT
COUNT(*) AS count,
AVG(query_time) AS avgQueryTime,
reflect("java.net.URLEncoder", "encode",query) AS urlEncodedQuery
FROM event.wdqs_external_sparql_query
WHERE year = 2020
AND month = 07
AND day = 22
AND namespace = "wdq"
GROUP BY query
ORDER BY avgQueryTime DESC
LIMIT 1000000