These are query pages in Wikidata:
| Name | Page view GUI (1-17 April) | Page view (API) | Disabled? | Needed in Wikidata? |
| Ancientpages | 51 | 240 | ||
| BrokenRedirects | 66 | 18 | ||
| Deadendpages | 47 | 0 | ||
| DoubleRedirects | 44 | 90 | ||
| FileDuplicateSearch | 34 | 0 | ||
| ListDuplicatedFiles | 35 | 0 | ||
| LinkSearch | 86 | 0 | ||
| Listredirects | 48 | 0 | ||
| Lonelypages | 47 | 0 | ||
| Longpages | 78 | 230 | ||
| MediaStatistics | 38 | 0 | ||
| MIMEsearch | 43 | 0 | ||
| Mostcategories | 43 | 0 | ||
| Mostimages | 2 | 0 | ||
| Mostinterwikis | 40 | 0 | ||
| Mostlinkedcategories | 43 | 0 | ||
| Mostlinkedtemplates | 1 | 0 | ||
| Mostlinked | 0 | 0 | ||
| Mostrevisions | 39 | 0 | ||
| Fewestrevisions | 49 | 0 | ||
| Shortpages | 48 | 114 | ||
| Uncategorizedcategories | 45 | 0 | ||
| Uncategorizedpages | 42 | 0 | ||
| Uncategorizedimages | 0 | 0 | ||
| Uncategorizedtemplates | 37 | 0 | ||
| Unusedcategories | 41 | 0 | ||
| Unusedimages | 1 | 0 | ||
| Wantedcategories | 58 | 120 | ||
| Wantedfiles | 46 | 120 | ||
| Wantedpages | 45 | 120 | ||
| Wantedtemplates | 40 | 120 | ||
| Unwatchedpages | 1 | 0 | ||
| Unusedtemplates | 41 | 0 | ||
| Withoutinterwiki | 46 | 0 | ||
They fall into three categories:
- We should disable them, they don't make sense for wikidata
- We need to move it out of query pages or find a way for it to work. Currently it's disabled or causing issues for production while it's needed
- It's okay to stay as is.
Query pages show cached data and information for editors, like clean up lists. But to build the cache they have cronjobs in production that runs really heavy queries once a week (for each special page in each wiki) and it takes really long time to finish (sometimes ten hours) and we had to disable those regardless if they are important or not but now it's the time to audit them and find a solution for the ones that matter and avoid wasteful db queries for special pages that never been used. I feel the best solution for some of those is to move them out of mediawiki and get these data from hadoop instead but I don't know how that can be done in analytics cluster.
Original report:
- AncientPages - last update in November 2019 (said to be updated twice a month)
- DeadendPages - last update in November 2019 (said to be updated twice a month)
- FewestRevisions - reported to be slow (T238199), last update in November 2019
- LonelyPages - seems unlikely any of those 5000 pages will get fixed
- MostCategories - empty, items cannot be categorized, useless for Wikidata
- MostInterwikis - empty, seems to only work with "old" interwiki, useless for Wikidata
See also: T309738: Move MediaWiki QueryPages computation to Hadoop