Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,297,296 1,566,847,148
All Images 5,321,951 1,085,338,024
API Users 119 16,928
Article Revisions 35,896 1,044,453,176
Articles 595 8,022,668
Blog Posts 250 891,408
Browser Activity Log 8,264,944 1,365,284,912
Categories 9,607 310,352
Collections 52,714 28,670,572
Contributors 12,687 685,098
Discussion Forums 19 2,076
Discussion Post Reports 11,095 10,837,068
Discussion Posts 482,754 147,217,304
Discussion Promoted Post 78 3,744
Discussion Threads 19,338 1,342,796
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 66,105 3,686,400
Game Plays 26,604 4,303,228
Geo Trips 1,191 5,395,328
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 32,378 1,241,632
Grid-Squares 348,067 23,962,320
Hectads 3,925 615,568
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 10,068,371 171,162,307
Images redirecting to new version 7,929 103,077
Leagues 357 44,420
Map Tiles 4,612 918,204
Moderation Actions 4,476,174 107,428,176
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,292
Picture of the Day images 4,330 69,280
Placename Gazetteer 285,339 17,548,368
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 101,984 15,509,636
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,085,527 310,457,220
Search Queries Performed (Historic) 68,215,076 7,915,748,132
Shared Descriptions 16,309 10,103,636
Shared Descriptions attached to images 367,457 7,716,597
Suggestion Ticket Item Changes 1,412,809 493,405,184
Suggestion Tickets 541,362 49,205,620
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,581,973 115,697,232
System Tasks 88 10,572
Tag Reports 3,251 288,804
Tags attached to Images 10,493,047 272,819,222
Unique Tags 191,115 8,980,716
User Preference Settings 18,925 1,204,316
Votes Cast 314,114 46,611,816
Primary Database Total 121,757,992 14,927,159,465
FileSystem Objects 25,218,054 4,010,131,344
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
please support us