PgHero

Space

Database Size: 199 MB

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

Relation Size 7d Growth
access_tokens 8 KB 0 Bytes
access_tokens_pkey 16 KB 0 Bytes
ahoy_events 680 KB 0 Bytes
ahoy_events_pkey 96 KB 0 Bytes
ahoy_messages 1.87 MB 24 KB
ahoy_messages_pkey 40 KB 0 Bytes
alerts 8 KB 0 Bytes
alerts_pkey 16 KB 0 Bytes
api_calls 7.43 MB 56 KB
api_calls_pkey 3.19 MB 24 KB
delayed_jobs 16 KB 0 Bytes
delayed_jobs_pkey 16 KB 0 Bytes
delayed_jobs_priority UNUSED 16 KB 0 Bytes
hacker_points 8 KB 0 Bytes
hacker_points_pkey 8 KB 0 Bytes
index_ahoy_events_on_time UNUSED 96 KB 0 Bytes
index_ahoy_events_on_user_id_and_user_type UNUSED 136 KB 0 Bytes
index_ahoy_events_on_visit_id UNUSED 104 KB 0 Bytes
index_ahoy_messages_on_token 88 KB 0 Bytes
index_ahoy_messages_on_user_id_and_user_type UNUSED 64 KB 0 Bytes
index_alerts_on_user_id_and_query_id 16 KB 0 Bytes
index_api_calls_on_created_at 3.19 MB 24 KB
index_mailkick_opt_outs_on_email UNUSED 8 KB 0 Bytes
index_mailkick_opt_outs_on_user_id_and_user_type UNUSED 8 KB 0 Bytes
index_media_on_tag_id_and_instagram_id 8 KB 0 Bytes
index_photos_on_tweet_id_and_url 8 KB 0 Bytes
index_queries_on_term 56 KB 0 Bytes
index_query_memberships_on_query_id 16 KB 0 Bytes
index_query_memberships_on_user_id_and_query_id 16 KB 0 Bytes
index_tags_on_name 40 KB 0 Bytes
index_top_tweeters_on_query_id 88 KB 0 Bytes
index_tweet_groups_on_query_id_and_seen_at UNUSED 40 KB 0 Bytes
index_tweets_on_query_id_and_retweet_and_created_at 4.3 MB 32 KB
index_tweets_on_query_id_and_twitter_id 3.59 MB 24 KB
index_tweets_on_tweet_group_id UNUSED 2.44 MB 24 KB
index_users_on_email 16 KB 0 Bytes
index_users_on_provider_and_uid 16 KB 0 Bytes
index_visits_on_user_id_and_user_type UNUSED 48 KB 0 Bytes
index_visits_on_visit_token 72 KB 0 Bytes
links 240 KB 0 Bytes
links_pkey 40 KB 0 Bytes
mailkick_opt_outs 8 KB 0 Bytes
mailkick_opt_outs_pkey 8 KB 0 Bytes
media 8 KB 0 Bytes
media_pkey 8 KB 0 Bytes
photos 8 KB 0 Bytes
photos_pkey 8 KB 0 Bytes
queries 128 KB 0 Bytes
queries_pkey 48 KB 0 Bytes
query_memberships 40 KB 0 Bytes
query_memberships_pkey 16 KB 0 Bytes
schema_migrations 16 KB 0 Bytes
tags 64 KB 0 Bytes
tags_pkey 16 KB 0 Bytes
top_tweeters 328 KB 0 Bytes
top_tweeters_pkey 184 KB 0 Bytes
trend_points 8 KB 0 Bytes
trend_points_pkey 8 KB 0 Bytes
tweet_groups 128 KB 0 Bytes
tweet_groups_pkey 32 KB 0 Bytes
tweets 158 MB 8 KB
tweets_pkey 2.32 MB 8 KB
unique_schema_migrations 16 KB 0 Bytes
users 104 KB 0 Bytes
users_pkey 16 KB 0 Bytes
visits 368 KB 0 Bytes
visits_pkey 32 KB 0 Bytes