Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,946,422 1,794,875,460
All Images 5,974,302 1,224,003,632
API Users 139 22,056
Article Revisions 44,012 1,299,157,636
Articles 646 9,587,584
Blog Posts 294 964,448
Browser Activity Log 13,480,495 2,265,706,220
Categories 9,603 310,212
Collections 47,147 27,945,960
Contributors 12,934 750,172
Discussion Forums 19 2,096
Discussion Post Reports 11,211 10,895,960
Discussion Posts 529,834 160,073,240
Discussion Promoted Post 78 3,744
Discussion Threads 20,545 1,452,644
Event Attendees 561 38,964
Events 60 14,708
FAQ Answers 158 127,548
FAQ Questions 174 15,320
Featured Search Results 342 12,792
Gallery Images 88,258 3,000,772
Game Plays 27,303 4,416,312
Geo Trips 1,369 6,201,640
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,633 1,281,556
Grid-Squares 351,963 26,119,912
Hectads 3,936 619,492
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 13,993,900 237,896,334
Images redirecting to new version 8,467 110,071
Leagues 377 49,380
Map Tiles 119,534 4,064,156
Moderation Actions 5,140,405 123,369,720
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 5,178 82,848
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 104,541 15,712,688
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,329,486 341,463,968
Search Queries Performed (Historic) 86,412,262 9,841,911,284
Shared Descriptions 18,487 11,582,716
Shared Descriptions attached to images 464,663 9,757,923
Suggestion Ticket Item Changes 1,567,776 555,511,424
Suggestion Tickets 676,494 61,645,452
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,755,816 135,096,308
System Tasks 88 10,672
Tag Reports 3,672 328,532
Tags attached to Images 13,464,244 403,927,320
Unique Tags 217,047 13,410,004
User Preference Settings 19,451 1,244,592
Votes Cast 395,156 60,995,928
Primary Database Total 155,146,897 18,757,340,932
FileSystem Objects 30,748,771 5,302,154,592
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