Getting basic database table, size and count statistics


(Sam Saffron) #1

The task rake db:stats will print out basic database stats.

./launcher enter app
rake db:stats 

table_name                 | row_estimate | size
---------------------------------------------------
email_logs                 | 4027838      | 611 MB
post_timings               | 9193590      | 388 MB
posts                      | 285127       | 266 MB
post_search_data           | 285127       | 194 MB
topic_views                | 4177774      | 185 MB
optimized_images           | 683840       | 136 MB
topic_users                | 1450648      | 134 MB
topic_links                | 647432       | 111 MB
unsubscribe_keys           | 905960       | 109 MB
incoming_links             | 1828047      | 107 MB
notifications              | 404150       | 91 MB
topics                     | 142508       | 80 MB
topic_search_data          | 142913       | 72 MB
topic_link_clicks          | 1159317      | 70 MB
directory_items            | 701916       | 51 MB
user_actions               | 629565       | 46 MB
users                      | 116988       | 35 MB
user_visits                | 519360       | 26 MB
post_stats                 | 284715       | 19 MB
topic_allowed_users        | 245966       | 14 MB
post_revisions             | 17369        | 14 MB
uploads                    | 52288        | 14 MB
email_tokens               | 119044       | 13 MB
user_options               | 116988       | 12 MB
scheduler_stats            | 101012       | 12 MB
user_search_data           | 116988       | 12 MB
draft_sequences            | 219310       | 11 MB
user_stats                 | 116988       | 11 MB
group_users                | 144370       | 9632 kB
user_emails                | 116988       | 9104 kB
github_user_infos          | 113617       | 7808 kB
user_profiles              | 116988       | 7464 kB
user_avatars               | 116988       | 7144 kB
user_profile_views         | 129138       | 7000 kB
user_archived_messages     | 106711       | 6280 kB
post_actions               | 81849        | 6136 kB
user_badges                | 78525        | 5240 kB
user_auth_tokens           | 20396        | 5096 kB
user_histories             | 46810        | 4552 kB
top_topics                 | 18387        | 3136 kB
etc... 

You can use this to provide us some extra information about the size of your db when asking for help that may be related to db size.