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.
Current reports
[edit]Articles
[edit]Blocks
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Indefinitely blocked IPs | 19,598 | Monthly | 13:25, 23 July 2025 (UTC) |
| Unusually long IP blocks (configuration) | 28 | Monthly | 08:05, 26 August 2024 (UTC) |
| Unusually long user blocks (configuration) | 1,321 | Monthly | 00:02, 19 May 2025 (UTC) |
Categories
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Empty categories (configuration) | 785 | Daily | 06:07, 7 August 2025 (UTC) |
| Polluted categories (configuration) | 18,311 | Weekly | 08:55, 1 August 2025 (UTC) |
| Polluted categories (2) (configuration) | 19,092 | Ad hoc | 00:00, 7 August 2025 (UTC) |
| Polluted categories (3) (configuration) | 168,675 | Ad hoc | 01:01, 7 August 2025 (UTC) |
| Polluted categories (4) (configuration) | 643 | Ad hoc | 02:00, 5 August 2025 (UTC) |
| Self-categorized categories (configuration) | 675 | Weekly | 12:03, 5 August 2025 (UTC) |
| Template categories containing articles (configuration) | 945 | Weekly | 09:26, 7 August 2025 (UTC) |
| Uncategorized categories (configuration) | 2,063 | Weekly | 09:07, 1 August 2025 (UTC) |
| User categories (configuration) | 28 | Monthly | 20:15, 20 July 2025 (UTC) |
Files
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Filenames with multiple extensions (configuration) | 18,793 | Weekly | 23:33, 03 August 2025 (UTC) |
| Files credited to Getty Images (configuration) | 7,033 | Weekly | 23:30, 03 August 2025 (UTC) |
| Files credited to The Associated Press (configuration) | 811 | Weekly | 23:30, 03 August 2025 (UTC) |
| Files with conflicting categorization (configuration) | 32,616 | Weekly | 12:04, 5 August 2025 (UTC) |
| Free files which link to Flickr (configuration) | 22,831 | Weekly | 23:33, 03 August 2025 (UTC) |
| Free files without a machine-readable source (configuration) | 39,929 | Weekly | 23:32, 03 August 2025 (UTC) |
| Largely duplicative file names (configuration) | 457 | Daily | 02:11, 8 August 2025 (UTC) |
| Largest orphaned free files by bytes (configuration) | 9,861 | Daily | 23:30, 03 August 2025 (UTC) |
| Non-free PDFs (configuration) | 415 | Weekly | 23:32, 03 August 2025 (UTC) |
| Orphaned low-resolution free files (configuration) | 53,897 | Weekly | 23:31, 03 August 2025 (UTC) |
| Overused non-free files (configuration) | 1,890 | Weekly | 09:25, 1 August 2025 (UTC) |
| Pages containing an unusually high number of non-free files (configuration) | 9,184 | Weekly | 09:23, 1 August 2025 (UTC) |
| Smallest orphaned free files by bytes (configuration) | 6,836 | Weekly | 23:30, 03 August 2025 (UTC) |
| Smallest orphaned free files by resolution (configuration) | 18,148 | Weekly | 23:31, 03 August 2025 (UTC) |
| Templates containing non-free files (configuration) | 316 | Weekly | 09:38, 1 August 2025 (UTC) |
| Unused non-free files (configuration) | 16,271 | Daily | 06:09, 7 August 2025 (UTC) |
Pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 155,168 | Weekly | 05:25, 3 August 2025 (UTC) |
| Blank single-author pages (configuration) | 41,110 | Weekly | 00:05, 5 August 2025 (UTC) |
| Malformed SPI Cases (configuration) | 90 | Continuously | 05:31, Friday, August 8, 2025 (UTC) |
| Old deletion discussions (configuration) | 8,822 | Weekly | 09:23, 1 August 2025 (UTC) |
| Orphaned talk pages (configuration) | 344 | Daily | 05:02, 8 August 2025 (UTC) |
| Orphaned talk subpages (configuration) | 1,578 | Weekly | 09:24, 1 August 2025 (UTC) |
| Pages with the most revisions (configuration) | 48,957 | Weekly | 00:31, 6 August 2025 (UTC) |
| Talk pages by size (configuration) | 16,231 | Weekly | 00:19, 8 August 2025 (UTC) |
Protections
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Fully protected user talk pages (configuration) | 14,225 | Weekly | 23:31, 03 August 2025 (UTC) |
| Fully salted titles with unusually long expiries | — | Monthly | — |
| Indefinitely semi-protected articles | — | Weekly | — |
| Indefinitely fully protected redirects (configuration) | 28 | Monthly | 00:25, 19 July 2025 (UTC) |
Redirects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,959,853 | Monthly | 17:53, 02 August 2025 (UTC) |
Statistics
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 84,800 | Monthly | 16:17, 22 July 2025 (UTC) |
| Page count by namespace (configuration) | 1,560 | Weekly | 00:13, 5 August 2025 (UTC) |
Stubs
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Long stubs | 20,590 | Daily | 17:27, 7 August 2025 (UTC) |
| Untagged stubs (configuration) | 35,207 | Weekly | 10:14, 1 August 2025 (UTC) |
Templates
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken WikiProject templates (configuration) | 350 | Weekly | 12:03, 5 August 2025 (UTC) |
| Free license tags which do not exist on Commons (configuration) | 1,241 | Weekly | 14:30, 11 November 2024 (UTC) |
| Invalid Navbar links (configuration) | 22,843 | Monthly | 12:27, 01 August 2025 (UTC) |
| Template sandboxes with categories (configuration) | 77,069 | Daily | 09:25, 7 August 2025 (UTC) |
| Templates containing links to disambiguation pages (configuration) | 7,381 | Weekly | 09:37, 1 August 2025 (UTC) |
| Templates transcluded on the most pages (configuration) | 372 | Weekly | 05:10, 3 August 2025 (UTC) |
| Transclusions of non-existent templates (configuration) | 4,561 | Daily | 05:27, 8 August 2025 (UTC) |
| Uncategorized templates | 5,519 | Daily | — |
| Unprotected templates with many transclusions (configuration) | 13 | Weekly | 15:35, 22 September 2022 (UTC) |
| Unused templates (configuration) | 28 | Daily | 06:12, 7 August 2025 (UTC) |
| Unused templates (filtered) (configuration) | 28 | Daily | 06:19, 7 August 2025 (UTC) |
Timed Text
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 666 | Weekly | 23:31, 03 August 2025 (UTC) |
WikiProjects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,993 | Weekly | 09:36, 1 August 2025 (UTC) |
| WikiProject watchers (configuration) | 66,316 | Weekly | 00:00, 06 August 2025 (UTC) |
| New WikiProjects (configuration) | 947 | Fortnightly | 20:07, 3 August 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 by namespace
[edit]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) | 11,721 | Monthly | 13:15, 19 July 2025 (UTC) |
| Confirmed autoconfirmed users (configuration) | 103 | Weekly | 23:31, 03 August 2025 (UTC) |
| Blocked users in user groups | 85,640 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 158,757 | Daily | 01:58, 7 August 2025 (UTC) |
| Inactive users with advanced permissions | 6,620 | Weekly | 17:25, 1 August 2025 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 6,386 | Weekly | 03:13, 3 August 2025 (UTC) |
| Longest active user article editing streaks (configuration) | 3,938 | Weekly | 15:24, 5 August 2025 (UTC) |
| Miscategorized users (configuration) | 32,646 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 6,634 | Daily | 04:13, 8 August 2025 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 23:53, 1 August 2025 (UTC) |
| Top new article reviewers (source) | 144,425 | Twice daily | 03:53, 8 August 2025 (UTC) |
| Unusually large IP talk pages (configuration) | 220 | Weekly | 23:30, 03 August 2025 (UTC) |
| Unusually large user talk pages (configuration) | 968 | Weekly | 23:31, 03 August 2025 (UTC) |
| Userpages with ".com" in their titles (configuration) | 78,912 | Weekly | 05:25, 3 August 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.