Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,936,994 2,238,316,252
All Images 6,968,717 1,376,619,728
API Users 193 37,380
Article Revisions 53,020 1,671,142,364
Articles 712 11,174,364
Blog Posts 327 962,152
Browser Activity Log 3,688,803 658,686,600
Categories 9,601 405,628
Collections 82,905 40,614,624
Contributors 13,420 845,460
Discussion Forums 20 2,188
Discussion Post Reports 11,450 11,009,072
Discussion Posts 617,256 182,376,860
Discussion Promoted Post 78 2,808
Discussion Threads 22,306 1,486,652
Event Attendees 722 47,188
Events 67 15,804
FAQ Answers 171 196,608
FAQ Questions 191 16,316
Featured Search Results 342 11,608
Gallery Images 125,300 3,759,000
Game Plays 28,124 4,761,120
Geo Trips 1,750 6,711,400
Geographical Contexts 49 26,056
Grid Squares fixed for Land Percentage 34,208 1,207,076
Grid-Squares 355,655 28,690,292
Hectads 3,937 628,704
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 19,240,632 327,090,744
Images redirecting to new version 9,387 122,031
Leagues 377 45,688
Map Tiles 287,691 8,918,421
Moderation Actions 6,143,068 129,004,428
Moderation Actions (Historic) 0
Myriads 110 22,328
Picture of the Day images 6,084 97,344
Placename Gazetteer 285,339 19,119,584
Projects 25 15,800
Quiz Questions 55 10,120
Quizes 9 384
Registered Users 113,148 16,999,532
Registered Users (Historic) 22,687 2,870,280
Search Queries Performed 2,057,360 483,797,204
Search Queries Performed (Historic) 138,543,767 15,517,708,944
Shared Descriptions 22,014 13,199,384
Shared Descriptions attached to images 680,430 14,289,030
Suggestion Ticket Item Changes 1,919,004 688,372,420
Suggestion Tickets 64,489 4,962,624
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,281 351,088
Tags attached to Images 17,918,940 1,456,472,064
Unique Tags 272,399 19,415,040
User Preference Settings 20,252 1,229,224
Votes Cast 595,350 98,537,044
Primary Database Total 210,426,513 25,297,531,494
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