PgHero

Space

Database Size: 169 MB

10 unused indices. Remove them with a migration for faster writes.

Relation Size 7d Growth
tweets 133 MB Unknown
api_calls 6.16 MB Unknown
index_tweets_on_query_id_and_retweet_and_created_at 3.38 MB Unknown
index_tweets_on_query_id_and_twitter_id 3.04 MB Unknown
api_calls_pkey 2.64 MB Unknown
index_api_calls_on_created_at 2.64 MB Unknown
tweets_pkey 1.91 MB Unknown
index_tweets_on_tweet_group_id UNUSED 1.81 MB Unknown
ahoy_messages 1.55 MB Unknown
ahoy_events 656 KB Unknown
visits 368 KB Unknown
top_tweeters 312 KB Unknown
top_tweeters_pkey 176 KB Unknown
index_ahoy_events_on_user_id_and_user_type UNUSED 136 KB Unknown
queries 128 KB Unknown
tweet_groups 128 KB Unknown
links 120 KB Unknown
users 104 KB Unknown
ahoy_events_pkey 96 KB Unknown
index_ahoy_events_on_time UNUSED 96 KB Unknown
index_ahoy_events_on_visit_id UNUSED 96 KB Unknown
index_ahoy_messages_on_token 88 KB Unknown
index_top_tweeters_on_query_id 72 KB Unknown
index_visits_on_visit_token 72 KB Unknown
tags 64 KB Unknown
index_ahoy_messages_on_user_id_and_user_type UNUSED 56 KB Unknown
index_queries_on_term 56 KB Unknown
index_visits_on_user_id_and_user_type UNUSED 48 KB Unknown
queries_pkey 48 KB Unknown
ahoy_messages_pkey 40 KB Unknown
index_tags_on_name 40 KB Unknown
index_tweet_groups_on_query_id_and_seen_at UNUSED 40 KB Unknown
query_memberships 40 KB Unknown
tweet_groups_pkey 32 KB Unknown
visits_pkey 32 KB Unknown
access_tokens_pkey 16 KB Unknown
alerts_pkey 16 KB Unknown
delayed_jobs 16 KB Unknown
delayed_jobs_pkey 16 KB Unknown
delayed_jobs_priority UNUSED 16 KB Unknown
index_alerts_on_user_id_and_query_id 16 KB Unknown
index_query_memberships_on_query_id 16 KB Unknown
index_query_memberships_on_user_id_and_query_id 16 KB Unknown
index_users_on_email 16 KB Unknown
index_users_on_provider_and_uid 16 KB Unknown
links_pkey 16 KB Unknown
query_memberships_pkey 16 KB Unknown
schema_migrations 16 KB Unknown
tags_pkey 16 KB Unknown
unique_schema_migrations 16 KB Unknown
users_pkey 16 KB Unknown
access_tokens 8 KB Unknown
alerts 8 KB Unknown
hacker_points 8 KB Unknown
hacker_points_pkey 8 KB Unknown
index_mailkick_opt_outs_on_email UNUSED 8 KB Unknown
index_mailkick_opt_outs_on_user_id_and_user_type UNUSED 8 KB Unknown
index_media_on_tag_id_and_instagram_id 8 KB Unknown
index_photos_on_tweet_id_and_url 8 KB Unknown
mailkick_opt_outs 8 KB Unknown
mailkick_opt_outs_pkey 8 KB Unknown
media 8 KB Unknown
media_pkey 8 KB Unknown
photos 8 KB Unknown
photos_pkey 8 KB Unknown
trend_points 8 KB Unknown
trend_points_pkey 8 KB Unknown