Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,419,280 1,608,861,680
All Images 5,443,759 1,110,607,012
API Users 120 17,028
Article Revisions 36,956 1,068,082,336
Articles 604 8,237,716
Blog Posts 270 912,904
Browser Activity Log 8,971,208 1,486,711,088
Categories 9,607 310,344
Collections 53,247 29,281,620
Contributors 12,738 687,852
Discussion Forums 19 2,076
Discussion Post Reports 11,107 10,838,544
Discussion Posts 491,921 149,541,136
Discussion Promoted Post 78 3,744
Discussion Threads 19,528 1,360,084
Event Attendees 486 32,548
Events 55 13,308
FAQ Answers 144 119,332
FAQ Questions 165 14,608
Featured Search Results 342 12,792
Gallery Images 69,723 4,734,976
Game Plays 26,673 4,314,680
Geo Trips 1,239 5,871,732
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 32,749 1,252,788
Grid-Squares 348,172 24,049,020
Hectads 3,926 616,244
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 10,368,502 176,264,534
Images redirecting to new version 8,002 104,026
Leagues 357 44,440
Map Tiles 4,805 918,204
Moderation Actions 4,600,901 110,421,624
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,458 71,328
Placename Gazetteer 285,339 17,548,368
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 102,446 15,583,488
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,136,051 310,457,220
Search Queries Performed (Historic) 70,806,836 8,196,100,904
Shared Descriptions 16,697 10,364,560
Shared Descriptions attached to images 383,179 8,046,759
Suggestion Ticket Item Changes 1,438,147 503,757,588
Suggestion Tickets 564,020 51,293,952
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,615,219 118,965,432
System Tasks 88 10,572
Tag Reports 3,307 294,876
Tags attached to Images 11,033,157 330,994,710
Unique Tags 194,890 9,154,944
User Preference Settings 19,041 1,212,264
Votes Cast 321,598 47,879,792
Primary Database Total 126,440,232 15,508,789,401
FileSystem Objects 25,783,798 4,105,421,528
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