Wikipedia:Database reports
Database reports query MediaWiki in search of patterns. Their output helps users by providing them with utility reports, used by community members to improve the encyclopedia (e.g., Untagged stubs (configuration)) and statistical reports, which have past and present informational value (e.g., Page count by namespace (configuration)).
Please discuss the current reports or suggest a new report on the talk page.
Some stale reports are listed on this page. If desired, and if the SQL is available, stale reports can often be revived using {{Database report}}.
Current reports
[edit]Articles
[edit]Blocks
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Indefinitely blocked IPs | 20,354 | Monthly | 13:25, 17 September 2025 (UTC) |
| Unusually long IP blocks (configuration) | 78 | Monthly | 08:05, 26 August 2024 (UTC) |
| Unusually long user blocks (configuration) | 1,371 | Monthly | 00:02, 19 May 2025 (UTC) |
Categories
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Categories categorized in red-linked categories (configuration) | 240 | No longer updated | 01:00, 09 October 2022 (UTC) |
| Empty categories (configuration) | 1,522 | Daily | 12:59, 5 October 2025 (UTC) |
| Polluted categories (configuration) | 25,972 | Weekly | 12:23, 5 October 2025 (UTC) |
| Polluted categories (2) (configuration) | 5,452 | Ad hoc | 00:00, 5 October 2025 (UTC) |
| Polluted categories (3) (configuration) | 178,334 | Ad hoc | 01:01, 5 October 2025 (UTC) |
| Polluted categories (4) (configuration) | 518 | Ad hoc | 02:00, 5 October 2025 (UTC) |
| Red-linked categories with incoming links (configuration) | 3,889 | Weekly | 22:00, 05 October 2022 (UTC) |
| Self-categorized categories (configuration) | 896 | Weekly | 10:08, 1 October 2025 (UTC) |
| Template categories containing articles | 946 | Daily | 08:25, 5 October 2025 (UTC) |
| Uncategorized categories (configuration) | 2,795 | Weekly | 12:35, 5 October 2025 (UTC) |
| User categories (configuration) | 28 | Monthly | 22:30, 14 September 2025 (UTC) |
| Polluted administrator categories | 58,470 | Monthly | 22:48, 28 September 2025 (UTC) |
Files
[edit]Pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 155,758 | Weekly | 05:25, 5 October 2025 (UTC) |
| Blank single-author pages (configuration) | 41,047 | Weekly | 14:00, 30 September 2025 (UTC) |
| Malformed SPI Cases (configuration) | 90 | Continuously | 03:09, Monday, October 6, 2025 (UTC) |
| Old deletion discussions (configuration) | 33,832 | Weekly | 13:30, 5 October 2025 (UTC) |
| Orphaned article deletion discussions (configuration) | 103 | Monthly | 11:12, 4 September 2022 (UTC) |
| Orphaned talk pages (configuration) | 266 | Daily | 05:02, 5 October 2025 (UTC) |
| Orphaned talk subpages (configuration) | 779 | Weekly | 13:31, 5 October 2025 (UTC) |
| Pages with the most distinct editors in the last month (configuration) | 49,748 | Daily | 05:26, 5 October 2025 (UTC) |
| Pages with the most revisions (configuration) | 49,033 | Weekly | 00:33, 1 October 2025 (UTC) |
| Talk pages by size (configuration) | 16,226 | Weekly | 00:19, 3 October 2025 (UTC) |
| Unfiled RfAs (configuration) | 2,109 | Weekly | 14:31, 11 November 2024 (UTC) |
Protections
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Semi-protected articles with unusually long expiries (configuration) | 86,317 | Monthly | 12:00, 07 October 2022 (UTC) |
| Fully protected articles with unusually long expiries (configuration) | 355 | Monthly | 12:05, 07 October 2022 (UTC) |
| Fully protected user talk pages (configuration) | 14,226 | Weekly | 23:30, 05 October 2025 (UTC) |
| Fully salted titles with unusually long expiries | — | Monthly | — |
| Indefinitely semi-protected articles | — | Weekly | — |
| Indefinitely semi-protected redirects (configuration) | 63 | Weekly | 00:30, 06 October 2022 (UTC) |
| Indefinitely fully protected redirects (configuration) | 28 | Monthly | 03:53, 13 September 2025 (UTC) |
Redirects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,818,435 | Monthly | 01:45, 03 October 2025 (UTC) |
Statistics
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 84,707 | Monthly | 22:30, 16 September 2025 (UTC) |
| Page count by namespace (configuration) | 1,566 | Weekly | 00:14, 30 September 2025 (UTC) |
Stubs
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Dubious stub categories (configuration) | 38,833 | Weekly | 10:00, 07 October 2022 (UTC) |
| Long stubs | 21,529 | Daily | 23:07, 5 October 2025 (UTC) |
| Untagged stubs (configuration) | 34,106 | Weekly | 13:49, 5 October 2025 (UTC) |
Templates
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| All free license tags (configuration) | 5,793 | Weekly | 14:30, 11 November 2024 (UTC) |
| Broken WikiProject templates (configuration) | 309 | Weekly | 10:08, 1 October 2025 (UTC) |
| Free license tags which do not exist on Commons (configuration) | 1,291 | Weekly | 14:30, 11 November 2024 (UTC) |
| Invalid Navbar links (configuration) | 16,109 | Monthly | 15:24, 01 October 2025 (UTC) |
| Template sandboxes with categories (configuration) | 76,577 | Daily | 09:25, 5 October 2025 (UTC) |
| Templates containing links to disambiguation pages (configuration) | 7,419 | Weekly | 13:41, 5 October 2025 (UTC) |
| Templates transcluded on the most pages (configuration) | 493 | Weekly | 05:12, 5 October 2025 (UTC) |
| Transclusions of non-existent templates (configuration) | 39,010 | Daily | 21:41, 5 October 2025 (UTC) |
| Uncategorized templates | 5,865 | Daily | — |
| Unprotected templates with many transclusions (configuration) | 63 | Weekly | 15:35, 22 September 2022 (UTC) |
| Unused templates (configuration) | 28 | Daily | 13:54, 5 October 2025 (UTC) |
| Unused templates (filtered) (configuration) | 28 | Daily | 14:07, 5 October 2025 (UTC) |
Timed Text
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 511 | Weekly | 23:31, 05 October 2025 (UTC) |
WikiProjects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,537 | Weekly | 13:38, 5 October 2025 (UTC) |
| WikiProjects by human changes | 240,970 | Daily | 13:26, 5 October 2025 (UTC) |
| WikiProjects with no activity | 44,375 | Weekly | 13:27, 29 September 2025 (UTC) |
| WikiProject watchers (configuration) | 66,373 | Weekly | 00:00, 01 October 2025 (UTC) |
| New WikiProjects | 1,458 | Daily | 05:26, 5 October 2025 (UTC) |
Third-party (disambiguations)
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with links to disambiguation pages | — | Daily | — |
| Templates with disambiguation links | — | Daily | — |
Third-party (non-free files)
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Mistagged non-free files | — | Daily | — |
Long pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Long pages | — | Tertian | — |
| Namespace | Talk namespace | Run frequency | Data as of |
|---|---|---|---|
| Main (Special:LongPages) | Talk | Monthly | — |
| User | User talk | Monthly | — |
| Wikipedia | Wikipedia talk | Monthly | — |
| File | File talk | Monthly | — |
| MediaWiki | MediaWiki talk | Monthly | — |
| Template | Template talk | Monthly | — |
| Help | Help talk | Monthly | — |
| Category | Category talk | Monthly | — |
| Portal | Portal talk | Monthly | — |
| Draft | Draft talk | Monthly | — |
| MOS | MOS talk | Monthly | — |
| TimedText | TimedText talk | Monthly | — |
| Module | Module talk | Monthly | — |
| Event | Event talk | Monthly | — |
Third-party (generic)
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Page moves grouped by user | — | Hourly | — |
| Largest pages | — | Dynamically | — |
| WikiProject Check Wikipedia reports | — | Daily | — |
Users
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Active editors with the longest-established accounts (configuration) | 12,875 | Monthly | 02:00, 30 September 2025 (UTC) |
| Confirmed autoconfirmed users (configuration) | 285 | Weekly | 23:31, 05 October 2025 (UTC) |
| Blocked users in user groups | 85,119 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 184,618 | Daily | 02:23, 27 August 2025 (UTC) |
| Inactive users with advanced permissions | 5,992 | Weekly | 06:57, 29 September 2025 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 6,652 | Weekly | 01:28, 30 September 2025 (UTC) |
| Longest active user article editing streaks (configuration) | 3,543 | Weekly | 15:42, 1 October 2025 (UTC) |
| Miscategorized users (configuration) | 32,696 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 7,056 | Daily | 10:05, 5 October 2025 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 14:33, 5 October 2025 (UTC) |
| Top new article reviewers (source) | 141,815 | Twice daily | 15:54, 5 October 2025 (UTC) |
| Unusually large IP talk pages (configuration) | 221 | Weekly | 23:30, 05 October 2025 (UTC) |
| Unusually large user talk pages (configuration) | 880 | Weekly | 23:30, 05 October 2025 (UTC) |
| Userpages with ".com" in their titles (configuration) | 79,028 | Weekly | 05:25, 5 October 2025 (UTC) |
Archived reports
[edit]An index of disabled reports is available here and in Category:Inactive Wikipedia database reports. You can also find an index of all DBR subpages at Special:PrefixIndex/Wikipedia:Database reports.