PgHero

Space

Database Size: 129 MB

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

Relation Size 7d Growth
tweets 98.7 MB Unknown
api_calls 4.79 MB Unknown
index_tweets_on_query_id_and_retweet_and_created_at 2.5 MB Unknown
index_tweets_on_query_id_and_twitter_id 2.5 MB Unknown
api_calls_pkey 2.06 MB Unknown
index_api_calls_on_created_at 2.06 MB Unknown
tweets_pkey 1.58 MB Unknown
index_tweets_on_tweet_group_id UNUSED 1.37 MB Unknown
ahoy_messages 1.25 MB Unknown
ahoy_events 464 KB Unknown
visits 312 KB Unknown
top_tweeters 272 KB Unknown
queries 128 KB Unknown
tweet_groups 128 KB Unknown
top_tweeters_pkey 120 KB Unknown
index_ahoy_events_on_user_id_and_user_type UNUSED 112 KB Unknown
links 112 KB Unknown
users 96 KB Unknown
ahoy_events_pkey 80 KB Unknown
index_ahoy_events_on_time UNUSED 80 KB Unknown
index_ahoy_events_on_visit_id UNUSED 80 KB Unknown
index_ahoy_messages_on_token UNUSED 72 KB Unknown
index_top_tweeters_on_query_id 72 KB Unknown
index_visits_on_visit_token 64 KB Unknown
tags 64 KB Unknown
index_queries_on_term 56 KB Unknown
index_ahoy_messages_on_user_id_and_user_type UNUSED 48 KB Unknown
queries_pkey 48 KB Unknown
index_tags_on_name 40 KB Unknown
index_tweet_groups_on_query_id_and_seen_at UNUSED 40 KB Unknown
index_visits_on_user_id_and_user_type UNUSED 40 KB Unknown
query_memberships 40 KB Unknown
ahoy_messages_pkey 32 KB Unknown
tweet_groups_pkey 32 KB Unknown
visits_pkey 32 KB Unknown
access_tokens_pkey 16 KB Unknown
alerts_pkey 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
delayed_jobs 8 KB Unknown
delayed_jobs_pkey 8 KB Unknown
delayed_jobs_priority UNUSED 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