Difference between revisions of "Workdocumentation 2024-05-12"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| + | {{WorkSequence|prev=Workdocumentation_2024-03-01|next=}} | ||
= snapquery statistics = | = snapquery statistics = | ||
| − | |||
== query_success == | == query_success == | ||
Revision as of 07:13, 12 May 2024
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 |