Space

Database Size: 19.7 GB

6 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :commentable_objects, name: "commentable_objects_event_type_type_idx"
remove_index :commentable_objects, name: "commentable_objects_secondary_player_id_idx"
remove_index :feeds, name: "idx_feeds_score"
remove_index :social_notifications, name: "idx_social_notifications_recipient_unread"
remove_index :comment_reports, name: "comment_reports_unresolved_idx"
remove_index :comment_mentions, name: "idx_comment_mentions_type_ref"

Relation	Size
commentable_objects	6.81 GB
idx_commentable_objects_epoch	3.07 GB
feeds	2.11 GB
unique_commentable_objects_ref_type_event_idx	1.89 GB
commentable_objects_created_date_idx	1.2 GB
commentable_objects_pkey	1.18 GB
idx_commentable_objects_weekly_events	773 MB
feeds_commentable_key	755 MB
feeds_pkey	716 MB
commentable_objects_type_idx	501 MB
commentable_objects_event_type_type_idx UNUSED	354 MB
user_activities	215 MB
commentable_objects_secondary_player_id_idx UNUSED	54.1 MB
user_activities_pkey	34.3 MB
user_activities_created_date_idx	34.1 MB
commentable_objects_home_coach_idx	17.6 MB
commentable_objects_away_coach_idx	17.5 MB
comment_statistic_users	7.25 MB
notification_preferences	5.44 MB
push_tokens	4.45 MB
comment_statistic_users_user_comment_statistic_unique	3.93 MB
comment_statistics	3.43 MB
commentable_objects_referee_id_league_id_idx	3.42 MB
users	2.49 MB
unique_user_type_reference	2.26 MB
comment_statistics_type_subtype_reference_cumulative_ux	2.13 MB
idx_comment_statistics_lookup	2.11 MB
devices	2.1 MB
user_favorite_players	2.06 MB
comment_statistic_users_pkey	2 MB
comments	1.59 MB
social_notifications	1.54 MB
idx_feeds_score UNUSED	1.16 MB
devices_device_key	1.13 MB
social_notifications_unique	1.08 MB
user_player_unique_idx	1.01 MB
notification_preferences_pkey	992 KB
comment_statistics_pkey	872 KB
devices_created_date_idx	832 KB
user_favorite_teams	832 KB
idx_social_notifications_recipient_created	744 KB
user_favorite_players_pkey	704 KB
idx_commentable_objects_comment_created	632 KB
devices_pkey	576 KB
push_tokens_pkey	488 KB
users_email_key	456 KB
user_language_preferences	440 KB
user_team_unique_idx	432 KB
users_devices	392 KB
user_support_teams	384 KB
social_notifications_pkey	376 KB
user_favorite_matches	336 KB
users_username_key	304 KB
user_favorite_teams_pkey	264 KB
user_language_preferences_user_language_unique_idx	264 KB
user_favorite_leagues	248 KB
user_id_device_id_unique_idx	240 KB
idx_commentable_objects_comment_ref	216 KB
comments_pkey	208 KB
idx_comments_reference	192 KB
idx_social_notifications_recipient_unread UNUSED	192 KB
user_language_preferences_pkey	192 KB
user_match_unique_idx	176 KB
users_devices_pkey	176 KB
stage_custom_name_map	168 KB
user_favorite_users	168 KB
user_support_teams_pkey	168 KB
user_support_teams_user_team_unique	168 KB
users_pkey	168 KB
user_league_unique_idx	144 KB
comments_user_id_idx	136 KB
user_favorite_teams_team_id_idx	136 KB
users_favorite_users_unique_idx	112 KB
user_favorite_matches_pkey	104 KB
users_phone_key	96 KB
user_favorite_leagues_pkey	88 KB
user_favorite_matches_match_id_idx	88 KB
user_favorite_users_favorite_user_id_idx	88 KB
user_favorite_users_user_id_created_idx	88 KB
users_favorite_users_pkey	64 KB
comment_mentions	56 KB
comment_reports	56 KB
flyway_users_schema_history	56 KB
user_favorite_leagues_league_id_idx	56 KB
ads_management	48 KB
device_app_states	48 KB
feed_filters	48 KB
feed_weights	48 KB
jwt_secrets	48 KB
languages	48 KB
referee_ratings	48 KB
server_status	48 KB
update_control	48 KB
user_feedback	48 KB
app_image_cache_version	40 KB
marketing_creative_names	40 KB
stage_custom_name_map_pkey	40 KB
trending_match_params	40 KB
trending_matches	40 KB
user_blocks	40 KB
user_favorite_coaches	40 KB
user_leagues	40 KB
email_verification	32 KB
user_lineups	32 KB
ads_management_page_key	16 KB
ads_management_pkey	16 KB
app_image_cache_version_pkey	16 KB
comment_mentions_pkey	16 KB
comment_reports_comment_idx	16 KB
comment_reports_pkey	16 KB
comment_reports_unique_reporter	16 KB
comment_reports_unnotified_idx	16 KB
comment_reports_unresolved_idx UNUSED	16 KB
device_app_states_device_key	16 KB
device_app_states_pkey	16 KB
email_verification_pkey	16 KB
email_verification_unique_idx	16 KB
feed_filters_pkey	16 KB
feed_weights_pkey	16 KB
feed_weights_type_key	16 KB
flyway_users_schema_history_pk	16 KB
flyway_users_schema_history_s_idx	16 KB
idx_comment_mentions_comment_id	16 KB
idx_comment_mentions_type_ref UNUSED	16 KB
jwt_secrets_pkey	16 KB
jwt_secrets_secret_key	16 KB
languages_name_key	16 KB
languages_pkey	16 KB
marketing_creative_names_pkey	16 KB
marketing_creative_names_unique	16 KB
referee_ratings_pkey	16 KB
referee_ratings_referee_id_match_id_idx	16 KB
referee_ratings_user_id_match_id_referee_id__unique_idx	16 KB
server_status_pkey	16 KB
trending_match_params_pkey	16 KB
trending_matches_match_key	16 KB
trending_matches_pkey	16 KB
update_control_operating_system_key	16 KB
user_blocks_blocked_idx	16 KB
user_blocks_pkey	16 KB
user_blocks_unique	16 KB
user_coach_unique_idx	16 KB
user_favorite_coaches_coach_id_idx	16 KB
user_favorite_coaches_pkey	16 KB
user_favorite_referees	16 KB
user_favorite_referees_pkey	16 KB
user_favorite_referees_referee_id_idx	16 KB
user_feedback_created_idx	16 KB
user_feedback_pkey	16 KB
user_league_user_league_unique_idx	16 KB
user_leagues_pkey	16 KB
user_lineups_pkey	16 KB
user_lineups_user_id_created_date_idx	16 KB
user_lineups_user_id_lineup_id_key	16 KB
user_referee_unique_idx	16 KB
version_build_number_os_unique_idx	16 KB