Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,759,955 1,729,455,268
All Images 5,785,882 1,183,592,864
API Users 134 20,916
Article Revisions 41,876 1,231,853,880
Articles 629 9,173,488
Blog Posts 286 948,880
Browser Activity Log 11,756,518 1,971,278,268
Categories 9,603 310,212
Collections 47,062 29,608,624
Contributors 12,861 745,938
Discussion Forums 19 2,096
Discussion Post Reports 11,167 10,890,772
Discussion Posts 517,167 156,170,788
Discussion Promoted Post 78 3,744
Discussion Threads 20,213 1,422,236
Event Attendees 548 37,488
Events 59 14,496
FAQ Answers 157 126,100
FAQ Questions 173 15,280
Featured Search Results 342 12,792
Gallery Images 81,292 3,495,556
Game Plays 27,154 4,391,236
Geo Trips 1,332 6,012,036
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,381 1,273,616
Grid-Squares 351,891 26,104,324
Hectads 3,933 618,132
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 11,373,781 193,354,277
Images redirecting to new version 8,274 107,562
Leagues 377 49,112
Map Tiles 51,606 1,754,604
Moderation Actions 4,948,664 118,767,936
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,849 77,584
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 103,864 15,787,496
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,270,273 359,777,620
Search Queries Performed (Historic) 81,674,500 9,341,604,168
Shared Descriptions 17,813 11,206,656
Shared Descriptions attached to images 434,291 9,120,111
Suggestion Ticket Item Changes 1,521,070 536,499,624
Suggestion Tickets 634,352 57,855,672
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,710,147 131,853,428
System Tasks 88 10,672
Tag Reports 3,584 320,724
Tags attached to Images 12,590,163 377,704,890
Unique Tags 209,101 9,816,388
User Preference Settings 19,299 1,233,032
Votes Cast 350,044 52,689,548
Primary Database Total 144,254,267 17,688,739,666
FileSystem Objects 27,458,176 4,726,186,288
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