Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,481,469 1,631,298,460
All Images 5,506,657 1,124,457,544
API Users 120 17,028
Article Revisions 37,351 1,079,689,868
Articles 610 8,276,568
Blog Posts 273 916,736
Browser Activity Log 9,426,438 1,566,958,864
Categories 9,606 310,316
Collections 53,452 29,483,620
Contributors 12,754 688,716
Discussion Forums 19 2,076
Discussion Post Reports 11,122 10,870,964
Discussion Posts 496,028 150,654,592
Discussion Promoted Post 78 3,744
Discussion Threads 19,672 1,372,640
Event Attendees 486 32,548
Events 55 13,308
FAQ Answers 146 120,324
FAQ Questions 165 14,608
Featured Search Results 342 12,792
Gallery Images 71,933 3,093,119
Game Plays 26,747 4,326,280
Geo Trips 1,254 5,899,716
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 32,960 1,259,320
Grid-Squares 348,242 25,818,912
Hectads 3,928 616,788
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 10,519,228 178,826,893
Images redirecting to new version 8,056 104,728
Leagues 377 49,012
Map Tiles 4,341 918,204
Moderation Actions 4,664,645 111,951,480
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,572 73,152
Placename Gazetteer 285,339 17,548,368
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 102,648 15,616,816
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,114,040 359,777,620
Search Queries Performed (Historic) 73,849,162 8,507,996,084
Shared Descriptions 16,865 10,498,680
Shared Descriptions attached to images 390,760 8,205,981
Suggestion Ticket Item Changes 1,452,584 510,042,076
Suggestion Tickets 576,853 52,433,212
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,634,780 123,560,840
System Tasks 88 10,572
Tag Reports 3,344 298,124
Tags attached to Images 11,322,601 339,678,030
Unique Tags 197,110 9,257,928
User Preference Settings 19,089 1,216,172
Votes Cast 326,157 48,669,556
Primary Database Total 130,613,622 16,025,755,603
FileSystem Objects 26,090,100 4,156,842,632
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