Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,004,612 1,814,348,588
All Images 6,031,773 1,236,099,460
API Users 140 22,156
Article Revisions 44,683 1,320,702,072
Articles 650 9,737,072
Blog Posts 295 967,828
Browser Activity Log 14,084,290 2,369,380,960
Categories 9,603 310,212
Collections 48,418 34,651,836
Contributors 12,958 751,564
Discussion Forums 19 2,096
Discussion Post Reports 11,223 11,017,488
Discussion Posts 534,970 161,389,524
Discussion Promoted Post 78 3,744
Discussion Threads 20,659 1,463,688
Event Attendees 577 39,920
Events 64 15,676
FAQ Answers 160 128,656
FAQ Questions 176 15,536
Featured Search Results 342 12,792
Gallery Images 91,202 3,100,868
Game Plays 27,454 4,440,664
Geo Trips 1,393 6,213,948
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,749 1,285,200
Grid-Squares 351,986 26,119,912
Hectads 3,936 619,608
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 14,442,902 245,529,368
Images redirecting to new version 8,527 110,851
Leagues 377 49,400
Map Tiles 136,349 4,635,866
Moderation Actions 5,200,417 124,810,008
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 5,272 84,352
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 104,803 15,753,328
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,423,205 341,463,968
Search Queries Performed (Historic) 88,247,111 10,032,776,440
Shared Descriptions 18,815 11,739,356
Shared Descriptions attached to images 480,215 10,084,515
Suggestion Ticket Item Changes 1,580,860 560,251,208
Suggestion Tickets 688,233 62,699,192
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,755,816 135,096,308
System Tasks 88 10,672
Tag Reports 3,736 333,872
Tags attached to Images 13,737,866 412,135,980
Unique Tags 219,312 13,513,432
User Preference Settings 19,530 1,250,348
Votes Cast 409,352 63,605,956
Primary Database Total 158,662,611 19,140,345,020
FileSystem Objects 31,429,089 5,429,095,268
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