Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 5,551,066 1,655,291,160
All Images 5,575,611 1,138,705,360
API Users 123 18,240
Article Revisions 37,776 1,094,122,492
Articles 613 8,309,040
Blog Posts 275 918,344
Browser Activity Log 9,859,170 1,643,183,400
Categories 9,605 310,288
Collections 46,144 29,608,144
Contributors 12,779 690,066
Discussion Forums 19 2,076
Discussion Post Reports 11,133 10,872,068
Discussion Posts 500,616 151,786,396
Discussion Promoted Post 78 3,744
Discussion Threads 19,785 1,382,956
Event Attendees 495 33,356
Events 56 13,720
FAQ Answers 152 123,572
FAQ Questions 168 14,788
Featured Search Results 342 12,792
Gallery Images 74,493 3,203,199
Game Plays 26,818 4,336,780
Geo Trips 1,264 5,911,164
Geographical Contexts 49 20,792
Grid Squares fixed for Land Percentage 33,149 1,265,160
Grid-Squares 348,359 25,838,024
Hectads 3,931 617,268
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 10,686,692 181,673,764
Images redirecting to new version 8,103 105,339
Leagues 377 49,012
Map Tiles 2,842 918,204
Moderation Actions 4,735,616 113,654,784
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 4,639 74,224
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 102,913 15,656,884
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,312,637 359,777,620
Search Queries Performed (Historic) 75,857,811 8,721,111,536
Shared Descriptions 17,088 10,663,344
Shared Descriptions attached to images 400,320 8,406,720
Suggestion Ticket Item Changes 1,467,966 516,285,912
Suggestion Tickets 590,376 53,701,580
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,654,807 126,366,696
System Tasks 88 10,572
Tag Reports 3,421 305,068
Tags attached to Images 11,614,542 348,436,260
Unique Tags 199,493 9,375,968
User Preference Settings 19,135 1,220,120
Votes Cast 332,111 49,578,828
Primary Database Total 133,989,412 16,395,515,564
FileSystem Objects 26,421,869 4,212,745,512
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