Wikipedia:Database reports

Technopedia Center

Faculty of Engineering and Computer Science
S1 Informatics S1 Information Systems S1 Information Technology S1 Computer Engineering S1 Electrical Engineering S1 Civil Engineering

faculty of Economics and Business
S1 Management S1 Accountancy

Faculty of Letters and Educational Sciences
S1 English literature S1 English language education S1 Mathematics education S1 Sports Education

Wikipedia:Database reports - Wikipedia

From Wikipedia, the free encyclopedia

Shortcuts

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

Report	Size (bytes)	Run frequency	Data as of
Articles by size (configuration)	62,102	Weekly	00:12, 9 September 2025 (UTC)
Articles containing linked e-mail addresses (configuration)	306	Weekly	05:18, 6 September 2025 (UTC)
Articles containing links to the user space (configuration)	4,800	Weekly	06:06, 6 September 2025 (UTC)
Featured articles by size (configuration)	303,662	Weekly	06:16, 6 September 2025 (UTC)
Forgotten articles (configuration)	25,733	Weekly	00:10, 8 September 2025 (UTC)
Good articles by size (configuration)	28	Weekly	06:32, 6 September 2025 (UTC)
Linked miscapitalizations (configuration)	206,562	Daily	13:25, 8 September 2025 (UTC)
Linked misspellings (configuration)	6,920	Daily	09:26, 8 September 2025 (UTC)
PRODed articles with deletion logs (configuration)	3,043	Twice daily	18:30, 8 September 2025 (UTC)
Most edited articles last month (configuration)	1,457	Weekly	00:12, 25 August 2025 (UTC)
Orphans with incoming links (configuration)	1,126	Daily	03:01, 9 September 2025 (UTC)
Unbelievable life spans (configuration)	898	Weekly	06:46, 6 September 2025 (UTC)
Interlanguage link templates need to fix (configuration)	1,209,781	Weekly	03:16, 6 September 2025 (UTC)
Vital articles update report (configuration)	4,118	Daily	08:21, 8 September 2025 (UTC)
Pages containing too many maintenance templates (configuration)	34,226	Weekly	11:54, 3 September 2025 (UTC)
Possibly out-of-process deletions	—	Every three days	—
Drafts with categories	—	Daily	—
Short descriptions containing invalid space characters	2,146	Daily	—
Articles with links to drafts	4,627	Daily	—
Biographies of dead people
Recent deaths (configuration)	15,581	Daily	03:29, 09 September 2025 (UTC)
Recent deaths (red links) (configuration)	8,285	Daily	03:29, 09 September 2025 (UTC)
Deaths from the COVID-19 pandemic (configuration)	531,147	Daily	03:29, 09 September 2025 (UTC)
Potential biographies of dead people (1) (configuration)	832	Weekly	06:36, 6 September 2025 (UTC)
Potential biographies of dead people (3) (configuration)	142,939	Weekly	06:38, 6 September 2025 (UTC)
Potential biographies of dead people (4) (configuration)	88,506	Weekly	06:38, 6 September 2025 (UTC)
Biographies of living people
Biographies of living people containing unsourced statements (configuration)	15,474	Weekly	06:46, 6 September 2025 (UTC)
Biographies of living people possibly eligible for deletion (configuration)	7,555	Weekly	06:42, 6 September 2025 (UTC)
Potential biographies of living people (1) (configuration)	3,079	Weekly	06:38, 6 September 2025 (UTC)
Potential biographies of living people (2) (configuration)	24,853	Weekly	06:39, 6 September 2025 (UTC)
Potential biographies of living people (3) (configuration)	28,680	Weekly	06:39, 6 September 2025 (UTC)
Shortest biographies of living people (configuration)	32,136	Daily	08:05, 8 September 2025 (UTC)
Uncategorized and unreferenced biographies of living people (configuration)	386	Weekly	06:46, 6 September 2025 (UTC)
Untagged and unreferenced biographies of living people (configuration)	1,887	Weekly	06:48, 6 September 2025 (UTC)
Untagged biographies of living people (configuration)	2,214	Weekly	06:47, 6 September 2025 (UTC)
Birthday today (configuration)	4,351	Daily	04:09, 7 September 2025 (UTC)

Blocks

Report	Size (bytes)	Run frequency	Data as of
Indefinitely blocked IPs	19,880	Monthly	13:25, 20 August 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)

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)	806	Daily	06:24, 8 September 2025 (UTC)
Polluted categories (configuration)	19,578	Weekly	05:45, 6 September 2025 (UTC)
Polluted categories (2) (configuration)	17,753	Ad hoc	00:01, 9 September 2025 (UTC)
Polluted categories (3) (configuration)	175,008	Ad hoc	01:01, 9 September 2025 (UTC)
Polluted categories (4) (configuration)	387	Ad hoc	02:00, 9 September 2025 (UTC)
Red-linked categories with incoming links (configuration)	3,889	Weekly	22:00, 05 October 2022 (UTC)
Self-categorized categories (configuration)	686	Weekly	04:35, 3 September 2025 (UTC)
Template categories containing articles	948	Daily	09:26, 8 September 2025 (UTC)
Uncategorized categories (configuration)	3,216	Weekly	05:57, 6 September 2025 (UTC)
User categories (configuration)	28	Monthly	21:21, 17 August 2025 (UTC)

Files

Report	Size (bytes)	Run frequency	Data as of
File description pages shadowing a Commons file or redirect (configuration)	231	Weekly	14:30, 11 November 2024 (UTC)
Filenames with multiple extensions (configuration)	18,971	Weekly	23:32, 07 September 2025 (UTC)
Files credited to Getty Images (configuration)	7,005	Weekly	23:30, 07 September 2025 (UTC)
Files credited to The Associated Press (configuration)	814	Weekly	23:30, 07 September 2025 (UTC)
Files for daily deletion with an impossible date (configuration)	155	Weekly	14:31, 11 November 2024 (UTC)
Files tagged for FfD missing an FfD nomination (configuration)	155	Weekly	14:30, 11 November 2024 (UTC)
Files with conflicting categorization (configuration)	32,562	Weekly	04:36, 3 September 2025 (UTC)
Files without a license tag (configuration)	1,988	Weekly	14:31, 11 November 2024 (UTC)
Free files which link to Flickr (configuration)	22,959	Weekly	23:31, 07 September 2025 (UTC)
Free files without a machine-readable source (configuration)	40,009	Weekly	23:31, 07 September 2025 (UTC)
Large fair-use images (configuration)	897	Weekly	14:30, 11 November 2024 (UTC)
Largely duplicative file names (configuration)	460	Daily	06:04, 9 September 2025 (UTC)
Largest orphaned free files by bytes (configuration)	9,927	Daily	23:30, 07 September 2025 (UTC)
Local files with a duplicate on Commons (configuration)	1,273	Weekly	14:31, 11 November 2024 (UTC)
Non-free files shadowing a Commons file (configuration)	1,138	Weekly	14:31, 11 November 2024 (UTC)
Non-free PDFs (configuration)	507	Weekly	23:31, 07 September 2025 (UTC)
Orphaned file talk pages (configuration)	518	Weekly	14:31, 11 November 2024 (UTC)
Orphaned files copied to Commons tagged keep local (configuration)	4,559	Weekly	14:32, 11 November 2024 (UTC)
Orphaned free files tagged keep local (configuration)	18,064	Weekly	14:30, 11 November 2024 (UTC)
Orphaned low-resolution free files (configuration)	53,937	Weekly	23:30, 07 September 2025 (UTC)
Orphaned PDFs (configuration)	2,728	Weekly	14:31, 11 November 2024 (UTC)
Overused non-free files (configuration)	1,792	Weekly	06:35, 6 September 2025 (UTC)
Pages containing an unusually high number of non-free files (configuration)	9,418	Weekly	06:34, 6 September 2025 (UTC)
Smallest orphaned free files by bytes (configuration)	6,818	Weekly	23:30, 07 September 2025 (UTC)
Smallest orphaned free files by resolution (configuration)	18,153	Weekly	23:30, 07 September 2025 (UTC)
Templates containing non-free files (configuration)	319	Weekly	06:43, 6 September 2025 (UTC)
Unused file redirects (configuration)	428,383	Weekly	00:09, 1 June 2024 (UTC)
Unused non-free files (configuration)	24,107	Daily	08:05, 8 September 2025 (UTC)

Pages

Report	Size (bytes)	Run frequency	Data as of
Bizarrely subnested userpages (configuration)	155,760	Weekly	05:25, 7 September 2025 (UTC)
Blank single-author pages (configuration)	41,022	Weekly	13:52, 2 September 2025 (UTC)
Malformed SPI Cases (configuration)	90	Continuously	06:06, Tuesday, September 9, 2025 (UTC)
Old deletion discussions (configuration)	11,278	Weekly	06:35, 6 September 2025 (UTC)
Orphaned article deletion discussions (configuration)	103	Monthly	11:12, 4 September 2022 (UTC)
Orphaned talk pages (configuration)	487	Daily	05:08, 9 September 2025 (UTC)
Orphaned talk subpages (configuration)	599	Weekly	06:35, 6 September 2025 (UTC)
Pages with the most revisions (configuration)	49,001	Weekly	00:31, 3 September 2025 (UTC)
Talk pages by size (configuration)	16,223	Weekly	00:19, 5 September 2025 (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,228	Weekly	23:30, 07 September 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	00:56, 16 August 2025 (UTC)

Redirects

Report	Size (bytes)	Run frequency	Data as of
Broken section anchors (configuration)	1,881,004	Monthly	15:51, 02 September 2025 (UTC)

Statistics

Report	Size (bytes)	Run frequency	Data as of
Articles with the most redirects (configuration)	84,756	Monthly	22:45, 19 August 2025 (UTC)
Page count by namespace (configuration)	1,565	Weekly	00:12, 9 September 2025 (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	20,654	Daily	17:27, 8 September 2025 (UTC)
Untagged stubs (configuration)	35,119	Weekly	06:47, 6 September 2025 (UTC)

Templates

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)	311	Weekly	04:35, 3 September 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)	13,147	Monthly	13:53, 01 September 2025 (UTC)
Template sandboxes with categories (configuration)	77,940	Daily	09:26, 8 September 2025 (UTC)
Templates containing links to disambiguation pages (configuration)	7,421	Weekly	06:43, 6 September 2025 (UTC)
Templates transcluded on the most pages (configuration)	493	Weekly	05:12, 7 September 2025 (UTC)
Transclusions of non-existent templates (configuration)	18,992	Daily	05:27, 9 September 2025 (UTC)
Uncategorized templates	5,280	Daily	—
Unprotected templates with many transclusions (configuration)	63	Weekly	15:35, 22 September 2022 (UTC)
Unused templates (configuration)	28	Daily	08:09, 8 September 2025 (UTC)
Unused templates (filtered) (configuration)	28	Daily	08:16, 8 September 2025 (UTC)

Timed Text

Report	Size (bytes)	Run frequency	Data as of
Timed Text without a corresponding File (configuration)	513	Weekly	23:30, 07 September 2025 (UTC)

WikiProjects

Report	Size (bytes)	Run frequency	Data as of
WikiProjects by changes (configuration)	202,730	Weekly	06:41, 6 September 2025 (UTC)
WikiProjects by human changes	242,887	Daily	13:26, 8 September 2025 (UTC)
WikiProjects with no activity	44,319	Weekly	13:26, 8 September 2025 (UTC)
WikiProject watchers (configuration)	66,371	Weekly	00:00, 03 September 2025 (UTC)
New WikiProjects	1,215	Weekly	13:25, 7 September 2025 (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 by namespace

Report	Size (bytes)	Run frequency	Data as of
Long pages	—	Tertian	—
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)

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)	11,619	Monthly	18:34, 16 August 2025 (UTC)
Confirmed autoconfirmed users (configuration)	182	Weekly	23:30, 07 September 2025 (UTC)
Blocked users in user groups	86,468	Fortnightly	—
Editors eligible for Autopatrol privilege (source)	184,618	Daily	02:23, 27 August 2025 (UTC)
Inactive users with advanced permissions	5,605	Weekly	04:44, 7 September 2025 (UTC)
List of Wikipedians by number of edits	—	Daily	—
Longest active user editing streaks (configuration)	6,488	Weekly	22:52, 7 September 2025 (UTC)
Longest active user article editing streaks (configuration)	3,582	Weekly	06:03, 3 September 2025 (UTC)
Miscategorized users (configuration)	32,696	Manually	20:40, 16 September 2022 (UTC)
Ownerless pages in the user space (configuration)	6,577	Daily	06:14, 8 September 2025 (UTC)
Potential U5s (configuration)	28	Weekly	07:15, 6 September 2025 (UTC)
Top new article reviewers (source)	154,308	Twice daily	03:54, 9 September 2025 (UTC)
Unusually large IP talk pages (configuration)	223	Weekly	23:30, 07 September 2025 (UTC)
Unusually large user talk pages (configuration)	915	Weekly	23:30, 07 September 2025 (UTC)
Userpages with ".com" in their titles (configuration)	78,972	Weekly	05:25, 7 September 2025 (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.

v t e Wikipedia community
For a listing of current collaborations, tasks, and news, see the Community portal. For a listing of ongoing discussions and current requests, see the Dashboard.
General community topics	Administration News The Signpost Goings-on In the media Meetups Mailing lists Wikipedians Statistics The Wikipedia Library Centralized discussion Village pump Idea lab Policy Proposals Technical Miscellaneous WMF Holidays Bots
Contents and grading	Requested articles Most-wanted articles Images needing articles Articles needing images Articles for creation WP:AFC/R WP:AFC/C Creating articles Help Vital articles Articles for improvement Peer review Good article nominations Featured article candidates Lists Pictures Topics Article translation Pages Main Page Errors
WikiProjects and collaborations	Directory Culture and the arts Geographical History and society Science, technology and engineering Wikipedia assistance and tasks Patrols Recent changes Counter-Vandalism Unit Accessibility Organizations category
Awards and feedback	Reward board Contests A nice cup of tea and a sit down Charitableness WikiLove Compliment before criticism Kindness Campaign Thanks!
Maintenance tasks	Task Center Open tasks Backlog Category Admin category Edit requests Category Database reports Category tracker Dusty articles Special pages New pages Recent changes Controversial issues
Administrators and noticeboards	Administrators' noticeboard Incidents Edit warring Vandalism Admin dashboard Admin requests Closure Page protection User permissions Sockpuppets Open proxies Revision deletion Oversight Request Usernames Changing Title blacklist OTRS Bureaucrats' Requests for adminship and bureaucratship Arbitration Committee Requests Enforcement
Content dispute resolution	Requests for comment Third opinion Dispute resolution noticeboard Biographies of living persons Conflict of interest External links Fringe theories Neutral point of view No original research Reliable sources
Other noticeboards and assistance	Regional notice boards Requests for help Category Asking questions Teahouse Help desk Reference desk Adopt-a-user Copyright assistance Copyright investigations Text problems Media questions Resource requests Mergers History mergers Moves Page importation Spam Blacklist Whitelist Bots Education General sanctions Editor sanctions Long-term abuse
Deletion discussions	Guide Admin Today Articles Templates Files Categories Redirects Miscellany Speedy Proposed BLP Review Undeletion Arguments to avoid Arguments to make Article Rescue
Elections and voting	Requests for comment (meta) Wikimedia Foundation elections WP Democracy Milestones
Directories, indexes, and summaries	Departments Edit summary legend Editor's index Essays FAQs Glossary Abbreviations Help Manual of Style Simplified Rules Five pillars Policies Guidelines Shortcuts Templates Citation templates Tips Today Tools Wiki markup
Media Category Templates