Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,243,856 2,065,869,120
All Images 6,272,355 1,270,046,096
API Users 156 25,936
Article Revisions 47,243 1,406,576,520
Articles 671 10,015,316
Blog Posts 308 994,856
Browser Activity Log 16,007,179 2,702,199,672
Categories 0
Collections 80,432 56,034,980
Contributors 13,032 755,856
Discussion Forums 19 2,096
Discussion Post Reports 11,246 11,021,044
Discussion Posts 549,893 165,771,344
Discussion Promoted Post 78 3,744
Discussion Threads 21,053 1,500,752
Event Attendees 637 44,196
Events 65 15,804
FAQ Answers 164 130,532
FAQ Questions 180 15,940
Featured Search Results 342 12,792
Gallery Images 100,842 3,025,260
Game Plays 27,672 4,478,748
Geo Trips 1,541 6,408,524
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,937 1,291,596
Grid-Squares 352,112 24,974,180
Hectads 3,937 289,384
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 16,106,029 273,802,493
Images redirecting to new version 8,794 114,322
Leagues 377 49,624
Map Tiles 180,159 6,125,406
Moderation Actions 5,429,301 130,303,224
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 5,521 88,336
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 106,464 16,008,444
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,629,976 411,011,740
Search Queries Performed (Historic) 99,647,834 11,339,636,680
Shared Descriptions 20,091 12,197,580
Shared Descriptions attached to images 571,317 11,997,657
Suggestion Ticket Item Changes 1,635,758 584,622,984
Suggestion Tickets 738,450 67,051,032
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,755,816 135,096,308
System Tasks 88 10,776
Tag Reports 3,836 342,412
Tags attached to Images 14,756,456 442,693,680
Unique Tags 246,777 11,714,920
User Preference Settings 19,639 1,259,056
Votes Cast 467,478 74,656,716
Primary Database Total 175,963,526 21,351,857,210
FileSystem Objects 33,943,063 5,868,017,804
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