Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,339,661 1,581,303,100
All Images 5,364,671 1,093,997,480
API Users 119 16,928
Article Revisions 36,154 1,050,730,552
Articles 597 8,058,184
Blog Posts 264 905,428
Browser Activity Log 8,501,753 1,405,547,328
Categories 9,607 310,344
Collections 52,908 28,840,188
Contributors 12,707 686,178
Discussion Forums 19 2,076
Discussion Post Reports 11,100 10,837,812
Discussion Posts 486,001 147,930,580
Discussion Promoted Post 78 3,744
Discussion Threads 19,393 1,347,908
Event Attendees 459 30,456
Events 54 13,076
FAQ Answers 137 115,952
FAQ Questions 162 14,300
Featured Search Results 342 12,792
Gallery Images 67,090 4,734,976
Game Plays 26,624 4,306,616
Geo Trips 1,212 5,705,900
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 32,424 1,243,248
Grid-Squares 348,102 23,989,600
Hectads 3,926 615,672
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 10,176,728 173,004,376
Images redirecting to new version 7,968 103,584
Leagues 357 44,420
Map Tiles 4,726 918,204
Moderation Actions 4,519,375 108,465,000
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,374 69,984
Placename Gazetteer 285,339 17,548,368
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 102,168 15,539,928
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,038,254 310,457,220
Search Queries Performed (Historic) 69,254,062 8,031,920,708
Shared Descriptions 16,447 10,181,940
Shared Descriptions attached to images 372,658 7,825,818
Suggestion Ticket Item Changes 1,420,857 496,245,528
Suggestion Tickets 548,474 49,853,660
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,592,417 116,639,832
System Tasks 88 10,572
Tag Reports 3,288 292,516
Tags attached to Images 10,683,121 277,761,146
Unique Tags 192,452 9,043,056
User Preference Settings 18,977 1,207,360
Votes Cast 316,093 46,942,188
Primary Database Total 123,452,863 15,128,188,450
FileSystem Objects 25,412,827 4,043,004,976
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