Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,582,681 2,191,311,584
All Images 6,613,457 1,346,327,404
API Users 178 31,544
Article Revisions 51,321 1,576,707,616
Articles 693 10,685,072
Blog Posts 322 1,018,476
Browser Activity Log 19,242,452 3,271,802,848
Categories 9,602 405,664
Collections 81,643 56,034,980
Contributors 13,247 768,326
Discussion Forums 19 2,096
Discussion Post Reports 11,369 11,034,128
Discussion Posts 579,417 175,166,404
Discussion Promoted Post 78 3,744
Discussion Threads 21,681 1,558,000
Event Attendees 673 47,104
Events 66 16,152
FAQ Answers 168 132,628
FAQ Questions 187 16,520
Featured Search Results 342 12,792
Gallery Images 115,607 3,468,210
Game Plays 27,916 4,520,184
Geo Trips 1,647 6,627,532
Geographical Contexts 49 27,232
Grid Squares fixed for Land Percentage 34,096 1,296,464
Grid-Squares 352,174 25,029,864
Hectads 3,937 604,120
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 17,868,883 303,771,011
Images redirecting to new version 9,175 119,275
Leagues 377 50,124
Map Tiles 229,419 7,800,246
Moderation Actions 5,778,831 138,691,944
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 5,835 93,360
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 110,986 16,702,448
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,814,982 457,117,888
Search Queries Performed (Historic) 118,915,035 13,399,677,404
Shared Descriptions 21,026 12,778,756
Shared Descriptions attached to images 620,626 13,033,146
Suggestion Ticket Item Changes 1,760,894 632,829,820
Suggestion Tickets 837,353 75,736,148
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,755,816 135,096,308
System Tasks 88 10,776
Tag Reports 4,019 327,288
Tags attached to Images 16,368,521 491,055,630
Unique Tags 259,811 12,304,548
User Preference Settings 19,941 1,281,992
Votes Cast 543,651 88,669,332
Primary Database Total 203,534,657 24,573,352,872
FileSystem Objects 37,074,666 6,451,904,488
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