Geograph Database Tables

Click a column header to change the sort order.

Table Rows Bytes
Active Images 6,465,075 2,149,135,200
All Images 6,495,081 1,320,917,528
API Users 173 30,032
Article Revisions 50,361 1,513,538,896
Articles 690 10,501,400
Blog Posts 318 1,014,428
Browser Activity Log 18,207,752 3,088,546,224
Categories 9,602 405,664
Collections 81,321 56,034,980
Contributors 13,175 764,150
Discussion Forums 19 2,096
Discussion Post Reports 11,327 11,029,024
Discussion Posts 568,622 171,492,216
Discussion Promoted Post 78 3,744
Discussion Threads 21,496 1,541,332
Event Attendees 673 47,104
Events 66 16,152
FAQ Answers 167 131,784
FAQ Questions 186 16,432
Featured Search Results 342 12,792
Gallery Images 111,121 3,333,630
Game Plays 27,859 4,510,300
Geo Trips 1,619 6,534,396
Geographical Contexts 49 27,232
Grid Squares fixed for Land Percentage 34,079 1,295,908
Grid-Squares 352,154 25,011,880
Hectads 3,937 603,596
Hectads (complete) 1,732 124,696
Image Notes 353 57,744
Images in Thumbnail Cache 17,338,718 294,758,206
Images redirecting to new version 9,026 117,338
Leagues 377 50,064
Map Tiles 213,066 7,244,244
Moderation Actions 5,656,818 135,763,632
Moderation Actions (Historic) 926,963 22,247,112
Myriads 110 20,312
Picture of the Day images 5,731 91,696
Placename Gazetteer 285,339 18,756,908
Projects 25 15,964
Quiz Questions 55 10,288
Quizes 9 404
Registered Users 109,351 16,452,704
Registered Users (Historic) 22,687 2,824,576
Search Queries Performed 2,708,402 457,117,888
Search Queries Performed (Historic) 112,790,240 12,745,198,224
Shared Descriptions 20,704 12,561,908
Shared Descriptions attached to images 602,501 12,652,521
Suggestion Ticket Item Changes 1,723,659 619,341,504
Suggestion Tickets 809,981 73,230,076
Suggestion Tickets (Historic) 627,093 57,490,736
SuperLayer Tiles 1,755,816 135,096,308
System Tasks 88 10,776
Tag Reports 3,984 356,628
Tags attached to Images 15,823,751 474,712,530
Unique Tags 256,265 12,133,960
User Preference Settings 19,832 1,273,492
Votes Cast 525,296 85,376,344
Primary Database Total 194,695,314 23,551,586,903
FileSystem Objects 36,019,747 6,254,405,392
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