Page MenuHomePhabricator
Paste P12119

(An Untitled Masterwork)
ActivePublic

Authored by Addshore on Wed, Jul 29, 10:11 AM.
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

Event Timeline

Addshore created this paste.Wed, Jul 29, 10:11 AM