Space
Database Size: 7.2 GB
1 unused index. Remove them for faster writes.
rails generate migration remove_unused_indexes
And paste
remove_index :flyway_users_schema_history, name: "flyway_users_schema_history_s_idx"
| Relation | Size |
|---|---|
| commentable_objects | 2.05 GB |
| feeds | 1.05 GB |
| idx_commentable_objects_epoch | 984 MB |
| idx_feeds_score | 762 MB |
| unique_commentable_objects_reference_id_type_idx | 676 MB |
| commentable_objects_created_date_idx | 413 MB |
| commentable_objects_pkey | 411 MB |
| feeds_commentable_key | 400 MB |
| feeds_pkey | 400 MB |
| commentable_objects_type_idx | 136 MB |
| comment_statistics | 136 KB |
| comment_statistic_users | 112 KB |
| comment_statistics_type_subtype_reference_cumulative_ux | 80 KB |
| idx_comment_statistics_lookup | 80 KB |
| comments | 72 KB |
| comment_statistic_users_user_comment_statistic_unique | 64 KB |
| users | 56 KB |
| devices | 48 KB |
| feed_filters | 48 KB |
| feed_weights | 48 KB |
| flyway_users_schema_history | 48 KB |
| jwt_secrets | 48 KB |
| languages | 48 KB |
| update_control | 48 KB |
| user_favorite_players | 48 KB |
| comment_statistic_users_pkey | 40 KB |
| comment_statistics_pkey | 40 KB |
| user_favorite_leagues | 40 KB |
| user_favorite_matches | 40 KB |
| user_favorite_teams | 40 KB |
| user_favorite_users | 40 KB |
| user_language_preferences | 40 KB |
| user_leagues | 40 KB |
| user_support_teams | 40 KB |
| users_devices | 40 KB |
| email_verification | 24 KB |
| comments_pkey | 16 KB |
| devices_device_key | 16 KB |
| devices_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 UNUSED | 16 KB |
| idx_comments_reference | 16 KB |
| jwt_secrets_pkey | 16 KB |
| jwt_secrets_secret_key | 16 KB |
| languages_name_key | 16 KB |
| languages_pkey | 16 KB |
| update_control_operating_system_key | 16 KB |
| user_favorite_leagues_pkey | 16 KB |
| user_favorite_matches_pkey | 16 KB |
| user_favorite_players_pkey | 16 KB |
| user_favorite_teams_pkey | 16 KB |
| user_id_device_id_unique_idx | 16 KB |
| user_language_preferences_pkey | 16 KB |
| user_language_preferences_user_language_unique_idx | 16 KB |
| user_league_unique_idx | 16 KB |
| user_league_user_league_unique_idx | 16 KB |
| user_leagues_pkey | 16 KB |
| user_match_unique_idx | 16 KB |
| user_player_unique_idx | 16 KB |
| user_support_teams_pkey | 16 KB |
| user_support_teams_user_team_unique | 16 KB |
| user_team_unique_idx | 16 KB |
| users_devices_pkey | 16 KB |
| users_email_key | 16 KB |
| users_favorite_users_pkey | 16 KB |
| users_favorite_users_unique_idx | 16 KB |
| users_phone_key | 16 KB |
| users_pkey | 16 KB |
| users_username_key | 16 KB |
| version_build_number_os_unique_idx | 16 KB |
| push_tokens | 8 KB |
| push_tokens_pkey | 8 KB |