Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,810,994 2,192,872,448
All Images 6,841,371 1,349,457,456
API Users 191 37,132
Article Revisions 52,577 1,654,053,280
Articles 705 11,054,052
Blog Posts 325 956,480
Browser Activity Log 2,563,169 452,229,768
Categories 9,601 405,628
Collections 82,517 40,201,668
Contributors 13,368 842,184
Discussion Forums 20 2,188
Discussion Post Reports 11,433 11,007,784
Discussion Posts 605,992 179,567,368
Discussion Promoted Post 78 2,808
Discussion Threads 22,120 1,469,268
Event Attendees 699 45,684
Events 67 15,804
FAQ Answers 169 196,608
FAQ Questions 188 16,012
Featured Search Results 342 11,608
Gallery Images 121,839 3,655,170
Game Plays 28,063 4,749,864
Geo Trips 1,734 6,652,688
Geographical Contexts 49 26,056
Grid Squares fixed for Land Percentage 34,164 1,205,756
Grid-Squares 352,204 28,458,828
Hectads 3,937 627,284
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 18,747,781 318,712,277
Images redirecting to new version 9,343 121,459
Leagues 377 45,688
Map Tiles 266,298 8,255,238
Moderation Actions 6,014,269 126,299,649
Moderation Actions (Historic) 0
Myriads 110 22,328
Picture of the Day images 6,018 96,288
Placename Gazetteer 285,339 19,119,584
Projects 25 15,800
Quiz Questions 55 10,120
Quizes 9 384
Registered Users 112,721 16,922,020
Registered Users (Historic) 22,687 2,870,280
Search Queries Performed 1,813,268 483,797,204
Search Queries Performed (Historic) 132,082,344 14,831,745,424
Shared Descriptions 21,679 13,003,548
Shared Descriptions attached to images 659,499 13,849,479
Suggestion Ticket Item Changes 1,871,779 673,440,536
Suggestion Tickets 34,619 2,545,152
Suggestion Tickets (Historic) 1,505,308 132,944,700
SuperLayer Tiles 1,755,816 121,990,280
System Tasks 88 10,020
Tag Reports 4,263 349,572
Tags attached to Images 17,333,192 1,456,472,064
Unique Tags 268,219 19,415,040
User Preference Settings 20,176 1,222,960
Votes Cast 577,900 95,299,452
Primary Database Total 200,973,183 24,278,579,860
Note, some of these totals might be slightly higher than the objects visible on the site, as tables often contain records for deleted items
You are not logged in login | register