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
Articles
Blocks
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Indefinitely blocked IPs | 21,613 | Monthly | 22:36, 16 May 2026 (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
| 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) | 3,558 | Daily | 04:26, 4 June 2026 (UTC) |
| Polluted categories (configuration) | 6,238 | Weekly | 06:12, 4 June 2026 (UTC) |
| Polluted categories (2) (configuration) | 10,534 | Ad hoc | 09:26, 4 June 2026 (UTC) |
| Polluted categories (3) (configuration) | 1,005,194 | Ad hoc | 04:25, 4 June 2026 (UTC) |
| Polluted categories (4) (configuration) | 3,353 | Ad hoc | 23:25, 3 June 2026 (UTC) |
| Red-linked categories with incoming links (configuration) | 3,889 | No longer updated | 22:00, 05 October 2022 (UTC) |
| Self-categorized categories (configuration) | 1,236 | Weekly | 23:27, 30 May 2026 (UTC) |
| Template categories containing articles | 1,032 | Daily | 18:05, 4 June 2026 (UTC) |
| Uncategorized categories (configuration) | 2,528 | Weekly | 14:09, 1 June 2026 (UTC) |
| User categories (configuration) | 28 | Monthly | 04:01, 25 May 2026 (UTC) |
| Polluted administrator categories | 60,611 | Monthly | 04:25, 25 May 2026 (UTC) |
Files
Pages
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Bizarrely subnested userpages (configuration) | 141,496 | Weekly | 23:25, 30 May 2026 (UTC) |
| Blank single-author pages (configuration) | 40,873 | Weekly | 16:01, 2 June 2026 (UTC) |
| Malformed SPI Cases (configuration) | 90 | Continuously | 20:58, Thursday, June 4, 2026 (UTC) |
| Old deletion discussions (configuration) | 27,648 | Weekly | 20:20, 4 June 2026 (UTC) |
| Orphaned article deletion discussions (configuration) | 103 | Monthly | 11:12, 4 September 2022 (UTC) |
| Orphaned talk pages (configuration) | 263 | Daily | 05:01, 4 June 2026 (UTC) |
| Orphaned talk subpages (configuration) | 1,211 | Weekly | 04:18, 2 June 2026 (UTC) |
| Pages with the most distinct editors in the last month (configuration) | 49,603 | Daily | 14:25, 4 June 2026 (UTC) |
| Pages with the most revisions (configuration) | 49,304 | Weekly | 00:27, 3 June 2026 (UTC) |
| Potential edit-warring or disruption (configuration) | 228,760 | Daily | 01:25, 4 June 2026 (UTC) |
| Talk pages by size (configuration) | 16,202 | Weekly | 00:19, 29 May 2026 (UTC) |
| Unfiled RfAs (configuration) | 2,109 | Weekly | 14:31, 11 November 2024 (UTC) |
Protections
| 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,219 | Weekly | 23:30, 31 May 2026 (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 | 04:00, 23 May 2026 (UTC) |
Redirects
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Broken section anchors (configuration) | 1,979,925 | Monthly | 17:15, 02 June 2026 (UTC) |
Statistics
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Articles with the most redirects (configuration) | 85,105 | Monthly | 02:01, 27 May 2026 (UTC) |
| Page count by namespace (configuration) | 1,565 | Weekly | 00:12, 2 June 2026 (UTC) |
Stubs
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Dubious stub categories (configuration) | 38,833 | Weekly | 10:00, 07 October 2022 (UTC) |
| Long stubs | 22,114 | Daily | 05:00, 4 June 2026 (UTC) |
| Untagged stubs (configuration) | 36,851 | Weekly | 23:57, 1 June 2026 (UTC) |
Templates
Timed Text
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Timed Text without a corresponding File (configuration) | 794 | Weekly | 23:30, 31 May 2026 (UTC) |
WikiProjects
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| WikiProjects by changes (configuration) | 202,621 | Weekly | 04:19, 2 June 2026 (UTC) |
| WikiProjects by human changes | 211,523 | Daily | 08:26, 4 June 2026 (UTC) |
| WikiProjects with no activity | 66,571 | Weekly | 05:25, 30 May 2026 (UTC) |
| WikiProject watchers (configuration) | 66,569 | Weekly | 00:00, 25 February 2026 (UTC) |
| New WikiProjects | 1,858 | Daily | 04:25, 4 June 2026 (UTC) |
Third-party (disambiguations)
| 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)
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Mistagged non-free files | — | Daily | — |
Long pages
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Long pages | — | Every three days | — |
| 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)
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Page moves grouped by user | — | Hourly | — |
| Largest pages | — | Dynamically | — |
| WikiProject Check Wikipedia reports | — | Daily | — |
Users
| Report | Size (bytes) | Run frequency | Data as of |
|---|---|---|---|
| Active editors with the longest-established accounts (configuration) | 12,811 | Monthly | 02:00, 2 June 2026 (UTC) |
| Confirmed autoconfirmed users (configuration) | 933 | Weekly | 23:30, 31 May 2026 (UTC) |
| Blocked users in user groups | 91,911 | Fortnightly | — |
| Editors eligible for Autopatrol privilege (source) | 182,696 | Daily | 01:52, 12 March 2026 (UTC) |
| Inactive users with advanced permissions | 6,067 | Weekly | 02:20, 30 May 2026 (UTC) |
| List of Wikipedians by number of edits | — | Daily | — |
| Longest active user editing streaks (configuration) | 7,965 | Weekly | 20:50, 4 June 2026 (UTC) |
| Longest active user article editing streaks (configuration) | 3,775 | Weekly | 11:01, 30 May 2026 (UTC) |
| Miscategorized users (configuration) | 32,696 | Manually | 20:40, 16 September 2022 (UTC) |
| Ownerless pages in the user space (configuration) | 8,674 | Daily | 12:04, 4 June 2026 (UTC) |
| Potential U5s (configuration) | 28 | Weekly | 22:12, 2 June 2026 (UTC) |
| Top new article reviewers (source) | 146,417 | Twice daily | 15:53, 4 June 2026 (UTC) |
| Unusually large IP talk pages (configuration) | 100 | Weekly | 23:30, 31 May 2026 (UTC) |
| Unusually large user talk pages (configuration) | 130 | Weekly | 23:30, 31 May 2026 (UTC) |
| Unverified user-rights userboxen (source) | 47,760 | Daily | 2026-06-04T10:47:52+00:00 |
| Userpages with ".com" in their titles (configuration) | 77,968 | Weekly | 05:25, 30 May 2026 (UTC) |
Archived reports
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.
See also
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.