Workdocumentation 2024-05-12

snapquery statistics

query_success

sqlquery -en snapquery -qp snapquery/samples/meta_query.yaml -qn query_success -f mediawiki

query

SELECT 
   COUNT(*) AS count,
   endpoint_name

FROM "QueryStats"
WHERE records>0
GROUP BY endpoint_name
ORDER BY 1 DESC

result

count	endpoint_name
739	wikidata
282	wikidata-scatter
134	wikidata-qlever

query_success_by_namespace

sqlquery -en snapquery -qp snapquery/samples/meta_query.yaml -qn query_success_by_namespace -f mediawiki

query

SELECT 
   COUNT(*) AS count,
   nq.namespace,
   qs.endpoint_name
   
FROM QueryStats qs
JOIN NamedQuery nq on qs.query_id=nq.query_id
WHERE records>0
GROUP BY endpoint_name,namespace
ORDER BY 2 ASC,1 DESC

result

count	namespace	endpoint_name
40	ceur-ws	wikidata-qlever
32	ceur-ws	wikidata
14	ceur-ws	wikidata-scatter
220	scholia	wikidata
90	scholia	wikidata-scatter
8	scholia	wikidata-qlever
5	snapquery-examples	wikidata
4	snapquery-examples	wikidata-qlever
4	snapquery-examples	wikidata-scatter
482	wikidata-examples	wikidata
174	wikidata-examples	wikidata-scatter
82	wikidata-examples	wikidata-qlever