Space

Database Size: 33.3 GB

11 unused indices. Remove them for faster writes.

rails generate migration remove_unused_indexes

And paste

remove_index :players, name: "players_name_ft_idx"
remove_index :coaches, name: "coaches_name_ft_idx"
remove_index :teams, name: "teams_name_ft_idx"
remove_index :venues, name: "venues_name_ft_idx"
remove_index :stages, name: "stages_name_ft_idx"
remove_index :stages, name: "stage_order_idx"
remove_index :referees, name: "referees_name_ft_idx"
remove_index :leagues, name: "leagues_name_ft_idx"
remove_index :countries, name: "countries_name_ft_idx"
remove_index :categories, name: "categories_name_ft_idx"
remove_index :flyway_football_schema_history, name: "flyway_football_schema_history_s_idx"

Relation	Size
match_status_tracker	7.13 GB
match_trends_pkey	5.23 GB
match_status_tracker_pkey	2.37 GB
team_players	1.95 GB
match_incidents	1.83 GB
league_hosts	1.5 GB
match_trends	1.27 GB
match_trends_unique_match_id	926 MB
match_players	831 MB
team_players_player_idx	818 MB
team_players_player_season_team_arrival_leaving_date_unique_idx	796 MB
match_players_pkey	777 MB
team_players_pkey	689 MB
match_team_statistics_per_minute	670 MB
match_player_statistics	664 MB
transfers	441 MB
league_hosts_pkey	393 MB
players	367 MB
season_player_statistics	353 MB
match_incidents_pkey	232 MB
match_players_match_lineup_include_id_player_id_team_type_idx	213 MB
players_pkey	196 MB
match_players_lineup_player_unique_idx	194 MB
league_host_season_relations_unique_idx	161 MB
player_market_values	156 MB
matches	150 MB
match_team_statistics_minute_match_team_minute_unique_idx	149 MB
team_players_player_id_season_team_id_idx	139 MB
match_statistics	134 MB
match_player_statistics_match_player_id_rating_idx	127 MB
team_players_season_team_id_player_id_idx	122 MB
match_player_statistics_pkey	117 MB
transfers_pkey	105 MB
idx_players_searchable_name_trgm	88 MB
match_injuries_pkey	85.1 MB
match_incidents_player_lookup_idx	82.7 MB
transfers_player_id_idx	78 MB
match_incidents_match_lineup_idx	77.7 MB
matches_pkey	77.3 MB
match_team_statistics_minute_match_minute_idx	75.4 MB
player_market_values_unique	73.2 MB
match_statistics_match_team_unique_idx	72.9 MB
match_incidents_deleted	72.8 MB
players_searchable_name_idx	68 MB
match_team_statistics	65.7 MB
team_players_season_team_idx	62.5 MB
season_player_statistics_season_player_team_unique_idx	62.1 MB
players_external_id_key	54.6 MB
transfers_from_team_idx	53.9 MB
transfers_to_team_idx	53 MB
match_player_statistics_match_player_id_key	52.8 MB
coaches	51.9 MB
players_name_ft_idx UNUSED	50.9 MB
matches_season_include_match_time_home_team_away_team_idx	50.2 MB
teams	42.8 MB
idx_season_player_stats_player_season	42.6 MB
transfers_deleted_transfer_time_idx	41.6 MB
transfers_transfer_time_idx	41.4 MB
match_team_statistics_per_minute_pkey	39.9 MB
match_statistics_pkey	39.7 MB
match_injuries	36.8 MB
season_player_statistics_pkey	29.9 MB
player_market_values_pkey	29.7 MB
goal_line_passes	28.2 MB
match_incidents_assist1_idx	24.2 MB
match_round_num_match_time_external_id_idx	24.1 MB
player_abilities	23.4 MB
match_lineups	20.5 MB
season_team_statistics	20.2 MB
season_player_statistics_season_rating_idx	20.1 MB
match_incidents_assist2_idx	19.3 MB
player_characteristics	18.9 MB
matches_away_team_home_team_id_idx	18.7 MB
teams_pkey	18.3 MB
match_team_statistics_minute_match_idx	16.2 MB
matches_external_id_key	13.1 MB
match_lineups_pkey	12.6 MB
standings_teams	12.4 MB
league_seasons	12.1 MB
stages	11.5 MB
matches_season_time_idx	11.3 MB
player_abilities_player_ability_unique_idx	11.2 MB
player_secondary_positions	10.9 MB
match_team_statistics_match_team_unique_idx	10.6 MB
match_goal_line	10 MB
matches_league_id_idx	9.98 MB
match_match_time_idx	9.45 MB
matches_season_id_match_time_desc_idx	9.38 MB
player_characteristics_player_type_unique_idx	8.77 MB
matches_season_id_idx	8.59 MB
coaches_pkey	8.42 MB
coaches_name_ft_idx UNUSED	7.92 MB
match_injuries_lineup_player_type_unique_idx	7.92 MB
matches_details_idx	7.75 MB
teams_name_ft_idx UNUSED	7.63 MB
goal_line_passes_ukey	7.51 MB
match_lineups_unique_match_id	6.98 MB
matches_status_id_idx	6.66 MB
live_standings_teams	6.64 MB
season_teams	6.39 MB
player_secondary_positions_player_position_unique_idx	6.35 MB
league_seasons_pkey	6.1 MB
player_abilities_pkey	5.93 MB
stages_pkey	5.41 MB
coaches_external_id_key	5.3 MB
goal_line_passes_pkey	5.3 MB
match_stage_idx	4.81 MB
live_standings_teams_pkey	4.8 MB
match_team_statistics_pkey	4.5 MB
venues	4.18 MB
player_characteristics_pkey	4.16 MB
seasons_pkey	4.05 MB
player_secondary_positions_pkey	3.77 MB
match_goal_line_ukey	3.72 MB
standings_teams_pkey	3.69 MB
teams_name_idx	3.61 MB
league_season_team_unique_idx	3.55 MB
teams_external_id_key	3.43 MB
seasons	3.42 MB
season_team_statistics_season_team_unique_idx	3.2 MB
team_colors	2.91 MB
venues_pkey	2.54 MB
referees_pkey	2.45 MB
season_teams_pkey	2.16 MB
standings_pkey	2.02 MB
stages_external_id_key	1.91 MB
team_coaches	1.88 MB
team_colors_team_id_key	1.84 MB
leagues	1.81 MB
referees	1.8 MB
standings_teams_team_id_stage_unique_idx	1.63 MB
match_goal_line_pkey	1.58 MB
standings_stages_pkey	1.51 MB
venues_name_ft_idx UNUSED	1.51 MB
season_team_statistics_pkey	1.41 MB
stages_name_ft_idx UNUSED	1.41 MB
standings	1.34 MB
team_colors_pkey	1.27 MB
team_coaches_coach_season_team_unique	1.2 MB
leagues_pkey	1.11 MB
stages_season_id_idx	1.09 MB
stage_order_idx UNUSED	928 KB
live_standings_teams_team_id_stage_unique_idx	872 KB
season_league_unique_idx	856 KB
team_coaches_pkey	760 KB
unique_seasons_idx	704 KB
referees_name_ft_idx UNUSED	632 KB
venues_external_id_key	608 KB
league_seasons_league_season_idx	600 KB
seasons_external_id_key	576 KB
standings_season_id_key	568 KB
standings_stages	544 KB
live_standings_stages_pkey	536 KB
seasons_external_year_idx	536 KB
leagues_name_ft_idx UNUSED	384 KB
league_title_holders	336 KB
referees_external_id_key	296 KB
seasons_uid_idx	272 KB
live_standings_stages	240 KB
league_title_holder_league_id_team_id_unique_idx	208 KB
countries	192 KB
standings_stages_external_id_key	168 KB
leagues_external_id_key	152 KB
season_league_current_season_idx	152 KB
standings_promotions_pkey	144 KB
live_standings_promotions	136 KB
live_standings_promotions_pkey	128 KB
live_standings	120 KB
league_title_holders_pkey	112 KB
standings_promotions	112 KB
live_standings_pkey	104 KB
idx_seasons_external_id_current	88 KB
live_standings_stages_external_id_key	88 KB
countries_name_ft_idx UNUSED	72 KB
leagues_category_id_idx	72 KB
flyway_football_schema_history	56 KB
categories	48 KB
categories_name_ft_idx UNUSED	48 KB
data_update_types	48 KB
event_reasons	48 KB
halftime_statistics	48 KB
league_fixture_priorities	48 KB
league_fixture_secondary_priorities	48 KB
live_standings_season_id_key	48 KB
match_statuses	48 KB
odds_companies	48 KB
technical_statistics	48 KB
update_times	48 KB
updated_season_players	48 KB
updated_season_teams	48 KB
suggested_teams	40 KB
update_controller	40 KB
countries_external_id_key	32 KB
countries_pkey	32 KB
categories_external_id_key	16 KB
categories_pkey	16 KB
countries_category_id_idx	16 KB
data_update_types_pkey	16 KB
event_reasons_pkey	16 KB
flyway_football_schema_history_pk	16 KB
flyway_football_schema_history_s_idx UNUSED	16 KB
halftime_statistics_pkey	16 KB
league_fixture_priorities_pkey	16 KB
league_fixture_priorities_user_country_id_unique	16 KB
league_fixture_priority_secondary_priorities_pkey	16 KB
league_fixture_secondary_priorities_user_country_id_unique	16 KB
live_standings_promotions_external_id_key	16 KB
match_statuses_pkey	16 KB
odds_companies_pkey	16 KB
standings_promotions_external_id_key	16 KB
suggested_teams_country_idx	16 KB
suggested_teams_country_team_unique_idx	16 KB
suggested_teams_pkey	16 KB
technical_statistics_pkey	16 KB
update_controller_pkey	16 KB
update_controller_update_type_key	16 KB
update_times_pkey	16 KB
update_times_update_type_unique_idx	16 KB
updated_season_players_pkey	16 KB
updated_season_players_season_id_key	16 KB
updated_season_teams_pkey	16 KB
updated_season_teams_season_id_key	16 KB