Movatterモバイル変換

[0]ホーム
URL:

Jump to content
WikipediaThe Free Encyclopedia
Search

Wikipedia:Database reports

From Wikipedia, the free encyclopedia
Reports from MediaWiki database queries
Shortcuts
"WP:DBR" redirects here; not to be confused withWP:2R.

Database reports queryMediaWiki 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 thetalk 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]
ReportSize (bytes)Run frequencyData as of
Articles by size (configuration)61,895Weekly00:12, 10 February 2026 (UTC)
Articles containing linked e-mail addresses (configuration)603Weekly10:00, 8 February 2026 (UTC)
Articles containing links to the user space (configuration)2,762Weekly12:19, 9 February 2026 (UTC)
Featured articles by size (configuration)306,429Weekly16:47, 11 February 2026 (UTC)
Forgotten articles (configuration)26,444Weekly00:10, 9 February 2026 (UTC)
Good articles by size (configuration)28Weekly09:06, 7 February 2026 (UTC)
Linked miscapitalizations (configuration)212,765Daily01:25, 14 February 2026 (UTC)
Linked misspellings (configuration)2,227Daily18:22, 13 February 2026 (UTC)
Multiple "Use xxx dates" templates  1,931Daily02:30, 14 February 2026 (UTC)
Multiple "Use xxx English" templates  9,516Daily19:25, 13 February 2026 (UTC)
PRODed articles with deletion logs (configuration)3,347Twice daily18:30, 13 February 2026 (UTC)
Most edited articles last month (configuration)1,399Weekly00:12, 9 February 2026 (UTC)
Orphans with incoming links (configuration)1,594Daily18:28, 13 February 2026 (UTC)
Unbelievable life spans (configuration)868Weekly14:46, 9 February 2026 (UTC)
Interlanguage link templates need to fix (configuration)1,218,930Weekly05:17, 14 February 2026 (UTC)
Vital articles update report (configuration)8,650Daily08:23, 13 February 2026 (UTC)
Pages containing too many maintenance templates (configuration)37,570Weekly10:00, 11 February 2026 (UTC)
Possibly out-of-process deletions—Every three days—
Drafts with categories—Daily—
Short descriptions containing invalid space characters3,656Daily—
Articles with links to drafts4,378Daily—
Biographies of dead people
Recent deaths (configuration)15,410Daily05:50, 14 February 2026 (UTC)
Recent deaths (red links) (configuration)7,955Daily05:50, 14 February 2026 (UTC)
Deaths from the COVID-19 pandemic (configuration)531,147Daily05:50, 14 February 2026 (UTC)
Potential biographies of dead people (1) (configuration)772Weekly12:22, 9 February 2026 (UTC)
Potential biographies of dead people (3) (configuration)168,786Weekly12:24, 9 February 2026 (UTC)
Potential biographies of dead people (4) (configuration)98,968Weekly12:24, 9 February 2026 (UTC)
Biographies of living people
Biographies of living people containing unsourced statements (configuration)15,419Weekly14:47, 9 February 2026 (UTC)
Biographies of living people possibly eligible for deletion (configuration)1,454Weekly12:27, 9 February 2026 (UTC)
Potential biographies of living people (1) (configuration)3,032Weekly12:25, 9 February 2026 (UTC)
Potential biographies of living people (2) (configuration)20,660Weekly12:25, 9 February 2026 (UTC)
Potential biographies of living people (3) (configuration)27,818Weekly12:26, 9 February 2026 (UTC)
Shortest biographies of living people (configuration)32,044Daily20:29, 13 February 2026 (UTC)
Uncategorized and unreferenced biographies of living people (configuration)344Weekly14:47, 9 February 2026 (UTC)
Untagged and unreferenced biographies of living people (configuration)349Weekly14:48, 9 February 2026 (UTC)
Untagged biographies of living people (configuration)3,098Weekly14:47, 9 February 2026 (UTC)
Birthday today (configuration)3,504Daily01:09, 24 January 2026 (UTC)

Blocks

[edit]
ReportSize (bytes)Run frequencyData as of
Indefinitely blocked IPs  18,644Monthly19:41, 21 January 2026 (UTC)
Unusually long IP blocks (configuration)78Monthly08:05, 26 August 2024 (UTC)
Unusually long user blocks (configuration)1,371Monthly00:02, 19 May 2025 (UTC)

Categories

[edit]
ReportSize (bytes)Run frequencyData as of
Categories categorized in red-linked categories (configuration)240No longer updated01:00, 09 October 2022 (UTC)
Empty categories (configuration)1,525Daily20:29, 13 February 2026 (UTC)
Polluted categories (configuration)5,058Weekly20:21, 13 February 2026 (UTC)
Polluted categories (2) (configuration)6,186Ad hoc05:25, 14 February 2026 (UTC)
Polluted categories (3) (configuration)962,588Ad hoc17:25, 12 February 2026 (UTC)
Polluted categories (4) (configuration)1,520Ad hoc22:25, 13 February 2026 (UTC)
Red-linked categories with incoming links (configuration)3,889Weekly22:00, 05 October 2022 (UTC)
Self-categorized categories (configuration)551Weekly10:05, 11 February 2026 (UTC)
Template categories containing articles  948Daily16:25, 13 February 2026 (UTC)
Uncategorized categories (configuration)1,985Weekly12:10, 9 February 2026 (UTC)
User categories (configuration)28Monthly04:01, 2 February 2026 (UTC)
Polluted administrator categories ​60,500Monthly17:27, 9 February 2026 (UTC)

Files

[edit]
ReportSize (bytes)Run frequencyData as of
File description pages shadowing a Commons file or redirect (configuration)231Weekly14:30, 11 November 2024 (UTC)
Filenames with multiple extensions (configuration)18,938Weekly23:32, 08 February 2026 (UTC)
Files credited to Getty Images (configuration)6,215Weekly23:30, 08 February 2026 (UTC)
Files credited to The Associated Press (configuration)813Weekly23:30, 08 February 2026 (UTC)
Files for daily deletion with an impossible date (configuration)155Weekly14:31, 11 November 2024 (UTC)
Files tagged for FfD missing an FfD nomination (configuration)155Weekly14:30, 11 November 2024 (UTC)
Files with conflicting categorization (configuration)36,134Weekly10:06, 11 February 2026 (UTC)
Files without a license tag (configuration)1,988Weekly14:31, 11 November 2024 (UTC)
Free files which link to Flickr (configuration)23,350Weekly23:32, 08 February 2026 (UTC)
Free files without a machine-readable source (configuration)40,232Weekly23:31, 08 February 2026 (UTC)
Large fair-use images (configuration)897Weekly14:30, 11 November 2024 (UTC)
Largely duplicative file names (configuration)657Daily10:00, 13 February 2026 (UTC)
Largest orphaned free files by bytes (configuration)10,006Daily23:30, 08 February 2026 (UTC)
Local files with a duplicate on Commons (configuration)1,273Weekly14:31, 11 November 2024 (UTC)
Non-free files shadowing a Commons file (configuration)1,138Weekly14:31, 11 November 2024 (UTC)
Non-free PDFs (configuration)198Weekly23:31, 08 February 2026 (UTC)
Orphaned file talk pages (configuration)518Weekly14:31, 11 November 2024 (UTC)
Orphaned files copied to Commons tagged keep local (configuration)4,559Weekly14:32, 11 November 2024 (UTC)
Orphaned free files tagged keep local (configuration)18,064Weekly14:30, 11 November 2024 (UTC)
Orphaned low-resolution free files (configuration)50,564Weekly23:31, 08 February 2026 (UTC)
Orphaned PDFs (configuration)2,728Weekly14:31, 11 November 2024 (UTC)
Overused non-free files (configuration)2,014Weekly12:22, 9 February 2026 (UTC)
Pages containing an unusually high number of non-free files (configuration)8,672Weekly12:20, 9 February 2026 (UTC)
Smallest orphaned free files by bytes (configuration)6,847Weekly23:30, 08 February 2026 (UTC)
Smallest orphaned free files by resolution (configuration)17,609Weekly23:30, 08 February 2026 (UTC)
Templates containing non-free files (configuration)454Weekly12:29, 9 February 2026 (UTC)
Unused file redirects (configuration)428,383Weekly00:09, 1 June 2024 (UTC)
Unused non-free files (configuration)24,552Daily20:30, 13 February 2026 (UTC)

Pages

[edit]
ReportSize (bytes)Run frequencyData as of
Bizarrely subnested userpages (configuration)156,241Weekly08:59, 12 February 2026 (UTC)
Blank single-author pages (configuration)40,873Weekly16:00, 10 February 2026 (UTC)
Malformed SPI Cases (configuration)90Continuously06:01, Saturday, February 14, 2026 (UTC)
Old deletion discussions (configuration)60,431Weekly12:21, 9 February 2026 (UTC)
Orphaned article deletion discussions (configuration)103Monthly11:12, 4 September 2022 (UTC)
Orphaned talk pages (configuration)456Daily05:01, 14 February 2026 (UTC)
Orphaned talk subpages (configuration)526Weekly12:21, 9 February 2026 (UTC)
Pages with the most distinct editors in the last month (configuration)50,224Daily05:25, 14 February 2026 (UTC)
Pages with the most revisions (configuration)49,207Weekly00:25, 11 February 2026 (UTC)
Potential edit-warring or disruption (configuration)208,159Daily20:25, 13 February 2026 (UTC)
Talk pages by size (configuration)16,240Weekly00:20, 13 February 2026 (UTC)
Unfiled RfAs (configuration)2,109Weekly14:31, 11 November 2024 (UTC)

Protections

[edit]
ReportSize (bytes)Run frequencyData as of
Semi-protected articles with unusually long expiries (configuration)86,317Monthly12:00, 07 October 2022 (UTC)
Fully protected articles with unusually long expiries (configuration)355Monthly12:05, 07 October 2022 (UTC)
Fully protected user talk pages (configuration)14,224Weekly23:30, 08 February 2026 (UTC)
Fully salted titles with unusually long expiries—Monthly—
Indefinitely semi-protected articles—Weekly—
Indefinitely semi-protected redirects (configuration)63Weekly00:30, 06 October 2022 (UTC)
Indefinitely fully protected redirects (configuration)28Monthly04:00, 31 January 2026 (UTC)

Redirects

[edit]
ReportSize (bytes)Run frequencyData as of
Broken section anchors (configuration)2,037,519Monthly22:04, 02 February 2026 (UTC)

Statistics

[edit]
ReportSize (bytes)Run frequencyData as of
Articles with the most redirects (configuration)85,047Monthly02:00, 4 February 2026 (UTC)
Page count by namespace (configuration)1,567Weekly00:14, 10 February 2026 (UTC)

Stubs

[edit]
ReportSize (bytes)Run frequencyData as of
Dubious stub categories (configuration)38,833Weekly10:00, 07 October 2022 (UTC)
Long stubs  20,339Daily18:25, 13 February 2026 (UTC)
Untagged stubs (configuration)34,249Weekly14:48, 9 February 2026 (UTC)

Templates

[edit]
ReportSize (bytes)Run frequencyData as of
All free license tags (configuration)5,793Weekly14:30, 11 November 2024 (UTC)
Broken WikiProject templates (configuration)311Weekly10:05, 11 February 2026 (UTC)
Free license tags which do not exist on Commons (configuration)1,291Weekly14:30, 11 November 2024 (UTC)
Invalid Navbar links (configuration)12,612Monthly14:39, 01 February 2026 (UTC)
Template sandboxes with categories (configuration)77,385Daily11:25, 13 February 2026 (UTC)
Templates containing links to disambiguation pages (configuration)7,283Weekly12:28, 9 February 2026 (UTC)
Templates transcluded on the most pages (configuration)493Weekly05:08, 8 February 2026 (UTC)
Transclusions of non-existent templates (configuration)18,114Daily05:08, 14 February 2026 (UTC)
Uncategorized templates5,959Daily—
Unprotected templates with many transclusions (configuration)63Weekly15:35, 22 September 2022 (UTC)
Unused templates (configuration)28Daily20:33, 13 February 2026 (UTC)
Unused templates (filtered) (configuration)28Daily20:41, 13 February 2026 (UTC)

Timed Text

[edit]
ReportSize (bytes)Run frequencyData as of
Timed Text without a corresponding File (configuration)696Weekly23:30, 08 February 2026 (UTC)

WikiProjects

[edit]
ReportSize (bytes)Run frequencyData as of
WikiProjects by changes (configuration)202,465Weekly12:27, 9 February 2026 (UTC)
WikiProjects by human changes  208,348Daily17:26, 13 February 2026 (UTC)
WikiProjects with no activity  68,501Weekly13:25, 9 February 2026 (UTC)
WikiProject watchers (configuration)66,521Weekly00:00, 11 February 2026 (UTC)
New WikiProjects  1,679Daily17:25, 13 February 2026 (UTC)

Third-party (disambiguations)

[edit]
ReportSize (bytes)Run frequencyData as of
Articles with links to disambiguation pages—Daily—
Templates with disambiguation links—Daily—

Third-party (non-free files)

[edit]
ReportSize (bytes)Run frequencyData as of
Mistagged non-free files—Daily—

Long pages

[edit]
ReportSize (bytes)Run frequencyData as of
Long pages—Tertian—
By namespace
NamespaceTalk namespaceRun frequencyData as of
Main (Special:LongPages)Talk

Talk (no subpages)

Monthly—
UserUser talk

User talk (no subpages)

Monthly—
WikipediaWikipedia talk

Wikipedia talk (no subpages)

Monthly—
FileFile talk

File talk (no subpages)

Monthly—
MediaWikiMediaWiki talk

MediaWiki talk (no subpages)

Monthly—
TemplateTemplate talk

Template talk (no subpages)

Monthly—
HelpHelp talk

Help talk (no subpages)

Monthly—
CategoryCategory talkMonthly—
PortalPortal talk

Portal talk (no subpages)

Monthly—
DraftDraft talkMonthly—
MOSMOS talkMonthly—
TimedTextTimedText talkMonthly—
ModuleModule talk

Module talk (no subpages)

Monthly—
EventEvent talkMonthly—

Third-party (generic)

[edit]
ReportSize (bytes)Run frequencyData as of
Page moves grouped by user—Hourly—
Largest pages—Dynamically—
WikiProject Check Wikipedia reports—Daily—

Users

[edit]
ReportSize (bytes)Run frequencyData as of
Active editors with the longest-established accounts (configuration)12,785Monthly02:00, 10 February 2026 (UTC)
Confirmed autoconfirmed users (configuration)545Weekly23:31, 08 February 2026 (UTC)
Blocked users in user groups86,307Fortnightly—
Editors eligible for Autopatrol privilege (source)185,168Daily01:58, 14 February 2026 (UTC)
Inactive users with advanced permissions  6,321Weekly19:52, 12 February 2026 (UTC)
List of Wikipedians by number of edits—Daily—
Longest active user editing streaks (configuration)7,764Weekly12:47, 11 February 2026 (UTC)
Longest active user article editing streaks (configuration)4,067Weekly06:51, 13 February 2026 (UTC)
Miscategorized users (configuration)32,696Manually20:40, 16 September 2022 (UTC)
Ownerless pages in the user space (configuration)8,241Daily10:04, 13 February 2026 (UTC)
Potential U5s (configuration)28Weekly12:12, 10 February 2026 (UTC)
Top new article reviewers (source)147,731Twice daily03:53, 14 February 2026 (UTC)
Unusually large IP talk pages (configuration)222Weekly23:30, 08 February 2026 (UTC)
Unusually large user talk pages (configuration)105Weekly23:30, 08 February 2026 (UTC)
Userpages with ".com" in their titles (configuration)81,287Weekly19:44, 10 February 2026 (UTC)

Archived reports

[edit]

An index of disabled reports is availablehere and inCategory:Inactive Wikipedia database reports. You can also find an index of all DBR subpages atSpecial:PrefixIndex/Wikipedia:Database reports.

See also

[edit]
For a listing of current collaborations, tasks, and news, see theCommunity portal.
For a listing of ongoing discussions and current requests, see theDashboard.
General community
topics
Contents andgrading
WikiProjects
andcollaborations
Awards andfeedback
Maintenance tasks
Administrators
andnoticeboards
Content dispute
resolution
Other noticeboards
and assistance
Deletion
discussions
Elections andvoting
Directories, indexes,
and summaries
Retrieved from "https://en.wikipedia.org/w/index.php?title=Wikipedia:Database_reports&oldid=1334516421"
Category:
[8]ページ先頭
©2009-2026 Movatter.jp