Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,822,308 1,751,450,612
All Images 5,849,199 1,197,092,108
API Users 136 21,740
Article Revisions 42,231 1,240,778,728
Articles 633 9,251,496
Blog Posts 292 960,104
Browser Activity Log 12,204,624 2,049,138,372
Categories 9,603 310,212
Collections 47,333 29,766,100
Contributors 12,874 746,692
Discussion Forums 19 2,096
Discussion Post Reports 11,185 10,892,952
Discussion Posts 521,103 157,396,736
Discussion Promoted Post 78 3,744
Discussion Threads 20,308 1,430,616
Event Attendees 556 38,512
Events 59 14,496
FAQ Answers 157 126,808
FAQ Questions 173 15,280
Featured Search Results 342 12,792
Gallery Images 83,650 2,844,100
Game Plays 27,217 4,402,228
Geo Trips 1,343 6,099,852
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,563 1,279,284
Grid-Squares 351,927 26,119,912
Hectads 3,934 618,560
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 12,027,390 204,465,630
Images redirecting to new version 8,316 108,108
Leagues 377 49,172
Map Tiles 80,131 2,724,454
Moderation Actions 5,012,690 120,304,560
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,961 79,376
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 104,063 15,820,968
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,370,506 359,777,620
Search Queries Performed (Historic) 83,082,712 9,489,609,948
Shared Descriptions 18,050 11,357,640
Shared Descriptions attached to images 443,833 9,320,493
Suggestion Ticket Item Changes 1,535,650 542,470,152
Suggestion Tickets 647,492 59,034,256
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,728,186 133,505,580
System Tasks 88 10,672
Tag Reports 3,615 323,240
Tags attached to Images 12,886,688 386,600,640
Unique Tags 211,560 9,933,392
User Preference Settings 19,353 1,236,964
Votes Cast 364,473 55,374,712
Primary Database Total 147,459,396 17,994,491,241
FileSystem Objects 28,386,949 4,872,619,324
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