Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,600,237 1,673,068,872
All Images 5,625,196 1,149,560,644
API Users 126 18,652
Article Revisions 38,400 1,111,241,936
Articles 616 8,340,840
Blog Posts 275 918,364
Browser Activity Log 10,346,731 1,727,323,600
Categories 9,605 310,288
Collections 46,335 29,608,220
Contributors 12,793 690,822
Discussion Forums 19 2,076
Discussion Post Reports 11,137 10,887,080
Discussion Posts 504,502 152,674,192
Discussion Promoted Post 78 3,744
Discussion Threads 19,864 1,390,284
Event Attendees 495 33,356
Events 56 13,720
FAQ Answers 153 124,172
FAQ Questions 169 14,908
Featured Search Results 342 12,792
Gallery Images 76,299 3,280,857
Game Plays 26,921 4,353,340
Geo Trips 1,280 5,919,744
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,217 1,267,152
Grid-Squares 351,850 26,048,472
Hectads 3,931 617,352
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 10,810,115 183,771,955
Images redirecting to new version 8,131 105,703
Leagues 377 49,032
Map Tiles 3,132 918,204
Moderation Actions 4,784,151 114,819,624
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,668 74,688
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 103,126 15,690,524
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,173,707 359,777,620
Search Queries Performed (Historic) 77,535,569 8,897,795,868
Shared Descriptions 17,233 10,776,240
Shared Descriptions attached to images 408,938 8,587,698
Suggestion Ticket Item Changes 1,478,387 520,422,428
Suggestion Tickets 599,493 54,584,812
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,671,734 127,437,816
System Tasks 88 10,572
Tag Reports 3,462 308,572
Tags attached to Images 11,845,537 355,366,110
Unique Tags 202,801 9,533,472
User Preference Settings 19,162 1,222,048
Votes Cast 335,635 50,157,020
Primary Database Total 136,580,488 16,720,705,017
FileSystem Objects 26,650,400 4,251,612,196
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