Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,377,593 1,594,129,484
All Images 5,401,861 1,101,550,824
API Users 120 17,028
Article Revisions 36,478 1,054,857,244
Articles 600 8,100,932
Blog Posts 270 912,904
Browser Activity Log 8,775,976 1,453,543,024
Categories 9,607 310,344
Collections 53,068 29,034,912
Contributors 12,716 686,664
Discussion Forums 19 2,076
Discussion Post Reports 11,103 10,838,328
Discussion Posts 488,901 148,659,396
Discussion Promoted Post 78 3,744
Discussion Threads 19,454 1,353,380
Event Attendees 473 31,596
Events 55 13,308
FAQ Answers 137 115,952
FAQ Questions 163 14,444
Featured Search Results 342 12,792
Gallery Images 68,287 4,734,976
Game Plays 26,642 4,309,704
Geo Trips 1,227 5,831,232
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 32,483 1,245,100
Grid-Squares 348,136 24,011,760
Hectads 3,926 615,724
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 10,267,867 174,553,739
Images redirecting to new version 7,982 103,766
Leagues 357 44,420
Map Tiles 4,678 918,204
Moderation Actions 4,558,169 109,396,056
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,404 70,464
Placename Gazetteer 285,339 17,548,368
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 102,300 15,560,800
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,068,772 310,457,220
Search Queries Performed (Historic) 69,877,080 8,098,981,308
Shared Descriptions 16,567 10,265,216
Shared Descriptions attached to images 377,753 7,932,813
Suggestion Ticket Item Changes 1,428,708 499,802,920
Suggestion Tickets 555,669 50,529,380
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,604,106 117,802,992
System Tasks 88 10,572
Tag Reports 3,303 294,144
Tags attached to Images 10,846,378 325,391,340
Unique Tags 193,498 9,091,324
User Preference Settings 19,014 1,210,144
Votes Cast 318,373 47,321,008
Primary Database Total 124,789,196 15,325,035,694
FileSystem Objects 25,589,133 4,072,621,624
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