Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,885,603 1,774,062,072
All Images 5,912,356 1,210,872,624
API Users 138 21,964
Article Revisions 42,797 1,258,475,068
Articles 637 9,340,212
Blog Posts 294 964,448
Browser Activity Log 12,987,367 2,181,336,892
Categories 9,603 310,212
Collections 47,597 29,872,768
Contributors 12,901 748,258
Discussion Forums 19 2,096
Discussion Post Reports 11,199 10,894,940
Discussion Posts 525,806 158,835,656
Discussion Promoted Post 78 3,744
Discussion Threads 20,443 1,442,980
Event Attendees 558 38,604
Events 60 14,708
FAQ Answers 158 127,548
FAQ Questions 173 15,280
Featured Search Results 342 12,792
Gallery Images 86,200 2,930,800
Game Plays 27,269 4,410,780
Geo Trips 1,359 6,160,496
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,607 1,280,776
Grid-Squares 351,948 26,119,912
Hectads 3,935 619,080
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 13,589,900 231,028,334
Images redirecting to new version 8,398 109,174
Leagues 377 49,316
Map Tiles 103,101 3,505,434
Moderation Actions 5,077,963 121,871,112
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 5,062 80,992
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 104,296 15,671,560
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,339,538 312,347,940
Search Queries Performed (Historic) 84,886,314 9,677,725,480
Shared Descriptions 18,243 11,438,408
Shared Descriptions attached to images 454,622 9,547,062
Suggestion Ticket Item Changes 1,552,859 549,665,676
Suggestion Tickets 662,998 60,415,604
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,746,049 133,629,708
System Tasks 88 10,672
Tag Reports 3,645 325,992
Tags attached to Images 13,185,099 395,552,970
Unique Tags 214,707 10,086,136
User Preference Settings 19,424 1,242,296
Votes Cast 376,059 57,556,220
Primary Database Total 152,175,604 18,372,344,328
FileSystem Objects 30,069,298 5,175,923,808
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