Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P12119
(An Untitled Masterwork)
Active
Public
Actions
Authored by
Addshore
on Jul 29 2020, 10:11 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F31952978: raw.txt
Jul 29 2020, 10:11 AM
2020-07-29 10:11:37 (UTC+0)
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
Event Timeline
Addshore
created this paste.
Jul 29 2020, 10:11 AM
2020-07-29 10:11:37 (UTC+0)
Log In to Comment