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 | 18,556 | Monthly | 01:25, 1 April 2025 (UTC) |
| Unusually long IP blocks (configuration) | 28 | Monthly | 08:05, 26 August 2024 (UTC) |
| Unusually long user blocks (configuration) | 1,472 | Monthly | 00:01, 21 April 2025 (UTC) |
Categories
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Categories categorized in red-linked categories (configuration) | 240 | Weekly | 01:00, 09 October 2022 (UTC) |
| Empty categories (configuration) | 758 | Daily | 08:10, 27 April 2025 (UTC) |
| Polluted categories (configuration) | 20,820 | Weekly | 04:25, 24 April 2025 (UTC) |
| Polluted categories (2) (configuration) | 5,267 | Ad hoc | 00:01, 27 April 2025 (UTC) |
| Polluted categories (3) (configuration) | 158,078 | Ad hoc | 01:00, 27 April 2025 (UTC) |
| Polluted categories (4) (configuration) | 744 | Ad hoc | 02:00, 25 April 2025 (UTC) |
| Red-linked categories with incoming links (configuration) | 3,839 | Weekly | 22:00, 05 October 2022 (UTC) |
| Self-categorized categories (configuration) | 932 | Weekly | 00:07, 22 April 2025 (UTC) |
| Template categories containing articles (configuration) | 870 | Weekly | Template categories containing articles; data as of the date at the bottom of this page. This report is updated daily, or on demand using the link on this page. This table is generated by querying the database replica and is periodically updated by a bot. No items retrieved. End of auto-generated report. |
| Uncategorized categories (configuration) | 3,471 | Weekly | 04:39, 24 April 2025 (UTC) |
| User categories (configuration) | 28 | Monthly | 20:01, 30 March 2025 (UTC) |
Files
[edit]Pages
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 155,069 | Weekly | 05:25, 27 April 2025 (UTC) |
| Blank single-author pages (configuration) | 41,286 | Weekly | 10:01, 27 April 2025 (UTC) |
| Malformed SPI Cases (configuration) | 90 | Continuously | 10:23, Sunday, April 27, 2025 (UTC) |
| Old deletion discussions (configuration) | 2,429 | Weekly | 04:50, 24 April 2025 (UTC) |
| Orphaned article deletion discussions (configuration) | 53 | Monthly | 11:12, 4 September 2022 (UTC) |
| Orphaned talk pages (configuration) | 265 | Daily | 05:02, 27 April 2025 (UTC) |
| Orphaned talk subpages (configuration) | 1,027 | Weekly | 04:51, 24 April 2025 (UTC) |
| Pages with the most revisions (configuration) | 48,904 | Weekly | 00:34, 23 April 2025 (UTC) |
| Talk pages by size (configuration) | 16,248 | Weekly | 00:18, 25 April 2025 (UTC) |
| Unfiled RfAs (configuration) | 2,059 | 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,267 | Monthly | 12:00, 07 October 2022 (UTC) |
| Fully protected articles with unusually long expiries (configuration) | 305 | Monthly | 12:05, 07 October 2022 (UTC) |
| Fully protected user talk pages (configuration) | 14,224 | Weekly | 23:31, 20 April 2025 (UTC) |
| Fully salted titles with unusually long expiries | — | Monthly | — |
| Indefinitely semi-protected articles | — | Weekly | — |
| Indefinitely semi-protected redirects (configuration) | 13 | Weekly | 00:30, 06 October 2022 (UTC) |
| Indefinitely fully protected redirects (configuration) | 28 | Monthly | 00:04, 26 April 2025 (UTC) |
Redirects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,841,295 | Monthly | 14:23, 02 April 2025 (UTC) |
Statistics
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 84,771 | Monthly | 16:02, 1 April 2025 (UTC) |
| Page count by namespace (configuration) | 1,559 | Weekly | 00:14, 22 April 2025 (UTC) |
Stubs
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Dubious stub categories (configuration) | 38,783 | Weekly | 10:00, 07 October 2022 (UTC) |
| Long stubs (configuration) | 40,718 | Weekly | 01:29, 27 April 2025 (UTC) |
| Untagged stubs (configuration) | 33,605 | Weekly | 05:05, 24 April 2025 (UTC) |
Templates
[edit]Timed Text
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 385 | Weekly | 23:31, 20 April 2025 (UTC) |
WikiProjects
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,282 | Weekly | 04:58, 24 April 2025 (UTC) |
| WikiProject watchers (configuration) | 65,955 | Weekly | 00:00, 23 April 2025 (UTC) |
| New WikiProjects (configuration) | 560 | Fortnightly | 16:01, 13 April 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 |
|---|---|---|---|
| Articles containing an unusually high number of non-free files | — | Daily | — |
| Non-free files used outside of mainspace | — | Daily | — |
| Overused non-free files | — | Daily | — |
| Mistagged non-free files | — | Daily | — |
Long pages by namespace
[edit]| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Long pages | — | Monthly | — |
| Long pages (Talk) | — | Monthly | — |
| Long pages (Talk) (no subpages) | — | Monthly | — |
| Long pages (User) | — | Monthly | — |
| Long pages (User talk) | — | Monthly | — |
| Long pages (User talk) (no subpages) | — | Monthly | — |
| Long pages (Wikipedia) | — | Monthly | — |
| Long pages (Wikipedia talk) | — | Monthly | — |
| Long pages (Wikipedia talk) (no subpages) | — | Monthly | — |
| Long pages (File) | — | Monthly | — |
| Long pages (File talk) | — | Monthly | — |
| Long pages (MediaWiki) | — | Monthly | — |
| Long pages (MediaWiki talk) | — | Monthly | — |
| Long pages (Template) | — | Monthly | — |
| Long pages (Template talk) | — | Monthly | — |
| Long pages (Help) | — | Monthly | — |
| Long pages (Help talk) | — | Monthly | — |
| Long pages (Category) | — | Monthly | — |
| Long pages (Category talk) | — | Monthly | — |
| Long pages (Portal) | — | Monthly | — |
| Long pages (Portal talk) | — | Monthly | — |
| Long pages (Draft) | — | Monthly | — |
| Long pages (Draft talk) | — | Monthly | — |
| Long pages (TimedText) | — | Monthly | — |
| Long pages (TimedText talk) | — | Monthly | — |
| Long pages (Module) | — | Monthly | — |
| Long pages (Module 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) | 11,673 | Monthly | 12:05, 26 April 2025 (UTC) |
| Confirmed autoconfirmed users (configuration) | 176 | Weekly | 23:31, 20 April 2025 (UTC) |
| Blocked users in user groups | 91,397 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 162,011 | Daily | 03:01, 25 April 2025 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 6,415 | Weekly | 19:00, 25 April 2025 (UTC) |
| Longest active user article editing streaks (configuration) | 3,584 | Weekly | 07:17, 26 April 2025 (UTC) |
| Miscategorized users (configuration) | 32,646 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 6,939 | Daily | 04:06, 27 April 2025 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 08:38, 25 April 2025 (UTC) |
| Top new article reviewers (source) | 146,216 | Twice daily | 03:53, 27 April 2025 (UTC) |
| Unusually large IP talk pages (configuration) | 502 | Weekly | 23:30, 20 April 2025 (UTC) |
| Unusually large user talk pages (configuration) | 915 | Weekly | 23:30, 20 April 2025 (UTC) |
| Userpages with ".com" in their titles (configuration) | 78,257 | Weekly | 05:25, 27 April 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.
