PgHero

Space

Database Size: 99.1 GB

17 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 :match_h2h_matches, name: "match_h2h_matches_league_id_idx"
remove_index :match_h2h_matches, name: "match_h2h_matches_season_id_idx"
remove_index :coaches, name: "coaches_name_ft_idx"
remove_index :the_sports_languages, name: "the_sports_languages_name_ft_idx"
remove_index :teams, name: "teams_name_ft_idx"
remove_index :stages, name: "stages_name_ft_idx"
remove_index :stages, name: "stage_order_idx"
remove_index :venues, name: "venues_name_ft_idx"
remove_index :match_compensation_matches, name: "match_compensation_matches_home_team_id_idx"
remove_index :match_compensation_matches, name: "match_compensation_matches_away_team_id_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"
remove_index :match_status_tracker, name: "idx_match_status_tracker_match_id"
Relation Size
team_players 10.3 GB
incident_custom_overwrite_logs 9.5 GB
match_trends_pkey 8.95 GB
team_players_pkey 6.57 GB
team_players_player_season_team_arrival_leaving_date_unique_idx 6.35 GB
match_player_statistics 6.03 GB
match_player_statistics_old 5.61 GB
match_players 4.64 GB
match_incidents 2.85 GB
match_players_pkey 2.25 GB
match_players_match_lineup_include_id_player_id_team_type_idx 2.04 GB
match_h2h_matches 2.02 GB
season_player_statistics 1.99 GB
team_players_season_team_player_arrival_idx 1.67 GB
match_trends 1.6 GB
team_players_player_id_season_team_id_idx 1.51 GB
league_hosts 1.5 GB
match_team_statistics_per_minute 1.24 GB
match_players_lineup_player_unique_idx 1.21 GB
match_trends_unique_match_id 1.14 GB
match_player_statistics_match_player_covering_idx 996 MB
match_player_statistics_match_player_id_rating_idx 929 MB
matches 919 MB
match_statistics 854 MB
mps_temp_mp_covering_idx 853 MB
mps_dump_load 747 MB
mps_temp_mpid_rating_idx 545 MB
match_incidents_pkey 545 MB
players 540 MB
match_player_statistics_pkey 525 MB
mps_temp_mpid_key 446 MB
transfers 440 MB
matches_season_include_match_time_home_team_away_team_idx 438 MB
match_player_statistics_match_player_id_key 435 MB
match_statistics_match_team_unique_idx 427 MB
match_incidents_player_lookup_idx 421 MB
league_hosts_pkey 394 MB
mps_temp_pkey 366 MB
season_player_statistics_season_player_team_unique_idx 343 MB
match_h2h_matches_h2h_category_ordinal_unique_idx 300 MB
match_team_statistics_minute_match_team_minute_unique_idx 286 MB
match_statistics_pkey 263 MB
match_h2h_goal_distributions 261 MB
players_pkey 239 MB
idx_season_player_stats_player_season 234 MB
match_incidents_assist1_idx 216 MB
player_market_values 209 MB
match_team_statistics 203 MB
team_squads 202 MB
match_lineups 200 MB
match_incidents_match_lineup_idx 200 MB
match_incidents_assist2_idx 198 MB
match_players_player_id_idx 196 MB
match_injuries_pkey 182 MB
matches_pkey 173 MB
season_team_statistics 166 MB
league_host_season_relations_unique_idx 161 MB
match_round_num_match_time_external_id_idx 160 MB
incident_custom_overwrite_logs_pkey 156 MB
idx_players_searchable_name_trgm 154 MB
standings_teams 151 MB
match_h2h_goal_distributions_unique_idx 146 MB
match_team_statistics_minute_match_minute_idx 146 MB
match_h2h_matches_pkey 132 MB
match_incidents_deleted 117 MB
transfers_pkey 115 MB
season_player_statistics_pkey 111 MB
player_season_ratings 101 MB
season_player_statistics_season_rating_idx 101 MB
team_squads_team_player_unique_idx 100 MB
player_market_values_unique 96.1 MB
matches_home_team_id_match_time_idx 95.4 MB
transfers_from_team_idx 95 MB
team_squads_pkey 93.4 MB
match_lineups_unique_match_id 93.4 MB
matches_external_id_key 92.8 MB
transfers_to_team_idx 92.7 MB
match_tvs 88.8 MB
matches_season_time_idx 87.8 MB
matches_season_id_match_time_desc_idx 85.8 MB
players_searchable_name_idx 82.9 MB
players_name_ft_idx UNUSED 81.4 MB
match_injuries 79.4 MB
match_team_statistics_per_minute_pkey 78.3 MB
transfers_player_id_idx 78 MB
players_external_id_key 75.1 MB
match_tvs_match_country_name_unique_idx 74.1 MB
team_live_squads_pkey 73.9 MB
match_h2h_matches_external_id_idx 72.6 MB
match_lineups_pkey 68.2 MB
matches_away_team_home_team_id_idx 67.6 MB
match_h2h_matches_status_id_idx 63.1 MB
match_h2h_matches_league_id_idx UNUSED 61.8 MB
match_h2h_matches_season_id_idx UNUSED 61.1 MB
match_h2h_matches_home_team_id_idx 58.8 MB
match_h2h_matches_away_team_id_idx 58.1 MB
coach_histories 54.3 MB
goal_line_passes 52.1 MB
coaches 51.9 MB
player_season_ratings_key_idx 51.6 MB
match_h2h_goal_distributions_pkey 50.1 MB
archive_missing_data 47 MB
live_standings_teams 44.7 MB
match_match_time_idx 43.4 MB
teams 42.8 MB
transfers_transfer_time_idx 42.6 MB
transfers_deleted_transfer_time_idx 41.6 MB
coach_career_seasons 41.3 MB
player_market_values_pkey 40 MB
matches_league_id_idx 39.8 MB
stages 34.9 MB
team_live_squads 33.6 MB
coach_transfer_balances 32.3 MB
matches_details_idx 31.5 MB
match_team_statistics_match_team_unique_idx 31.1 MB
match_stage_idx 30.9 MB
season_teams 30.2 MB
matches_status_id_idx 30.2 MB
season_team_statistics_season_team_unique_idx 26.7 MB
player_abilities 25.4 MB
the_sports_languages 24 MB
player_characteristics 23.5 MB
match_compensation_matches 22.3 MB
league_season_team_unique_idx 21.5 MB
teams_pkey 21.2 MB
season_teams_pkey 20.8 MB
standings_teams_pkey 19.3 MB
team_live_squads_team_player_unique_idx 18.5 MB
match_tvs_pkey 18.3 MB
match_goal_line 18.1 MB
coach_career_seasons_pkey 16.5 MB
match_injuries_lineup_player_type_unique_idx 16.1 MB
match_lineups_home_coach_id_idx 16 MB
match_lineups_away_coach_id_idx 15.9 MB
standings 15.7 MB
match_expected_goals_per_minute 15.2 MB
coach_histories_pkey 15.1 MB
archive_missing_data_match_type_unique_idx 14.7 MB
coach_transfer_balances_pkey 13.9 MB
standings_teams_team_id_stage_unique_idx 13.4 MB
match_team_statistics_pkey 13.4 MB
goal_line_passes_ukey 13.2 MB
player_abilities_player_ability_unique_idx 12.2 MB
player_characteristics_player_type_unique_idx 11.3 MB
player_secondary_positions 10.9 MB
season_team_statistics_pkey 10.1 MB
coaches_pkey 9.8 MB
goal_line_passes_pkey 9.33 MB
league_seasons_pkey 9.11 MB
live_standings_teams_pkey 8.82 MB
match_tvs_country_id_idx 8.8 MB
the_sports_languages_external_id_type_language_key 8.72 MB
stages_pkey 8.64 MB
match_odds 8.48 MB
player_ranking_overall 8.05 MB
player_season_ratings_season_team_idx 8.02 MB
league_seasons 7.95 MB
coaches_name_ft_idx UNUSED 7.92 MB
the_sports_languages_name_ft_idx UNUSED 7.84 MB
teams_name_ft_idx UNUSED 7.63 MB
standings_pkey 7.52 MB
player_abilities_pkey 7.17 MB
coach_histories_external_updated_at_idx 6.97 MB
players_uid_null_market_value_idx 6.79 MB
player_characteristics_pkey 6.55 MB
match_goal_line_ukey 6.52 MB
standings_stages 6.52 MB
player_secondary_positions_player_position_unique_idx 6.45 MB
match_compensation_matches_unique_idx 6.27 MB
archive_missing_data_pkey 6.26 MB
seasons 5.51 MB
coach_career_seasons_coach_id_idx 5.44 MB
match_compensation_records 5.42 MB
coaches_external_id_key 5.36 MB
coach_histories_coach_id_idx 5.33 MB
seasons_pkey 5.3 MB
the_sports_languages_pkey 5.18 MB
match_expected_goals_minute_match_minute_unique_idx 5.13 MB
player_ranking_overall_rank_idx 5.03 MB
match_h2hs 4.83 MB
standings_promotions 4.69 MB
standings_stages_pkey 4.66 MB
coach_transfer_balances_coach_id_idx 4.51 MB
venues 4.18 MB
match_compensation_matches_pkey 3.98 MB
season_teams_team_id_idx 3.95 MB
player_secondary_positions_pkey 3.92 MB
match_odds_unique_match_id 3.84 MB
teams_name_idx 3.63 MB
stages_name_ft_idx UNUSED 3.52 MB
teams_external_id_key 3.51 MB
matches_referee_id_status_id_season_id_idx 3.46 MB
referees_pkey 3.41 MB
match_compensation_matches_external_id_idx 3.13 MB
venues_pkey 3.02 MB
team_colors 3 MB
stages_external_id_key 2.89 MB
coach_top_rated 2.79 MB
match_goal_line_pkey 2.78 MB
match_h2hs_match_id_unique_idx 2.53 MB
match_compensation_records_unique_idx 2.44 MB
standings_season_id_key 2.38 MB
match_compensation_records_pkey 2.29 MB
player_ranking_overall_player_idx 2.23 MB
leagues 2.14 MB
match_expected_goals 2.09 MB
match_expected_goals_per_minute_pkey 2.09 MB
match_odds_pkey 2.05 MB
live_standings_teams_team_id_stage_unique_idx 1.87 MB
stages_season_id_idx 1.87 MB
team_colors_team_id_key 1.86 MB
referees 1.8 MB
related_incidents 1.75 MB
notified_mvps 1.66 MB
stage_order_idx UNUSED 1.65 MB
coach_top_rated_rank_idx 1.59 MB
venues_name_ft_idx UNUSED 1.51 MB
match_compensations 1.49 MB
leagues_pkey 1.48 MB
match_h2hs_pkey 1.4 MB
match_compensation_matches_home_team_id_idx UNUSED 1.34 MB
team_coaches 1.31 MB
coach_top_rated_coach_idx 1.3 MB
team_colors_pkey 1.29 MB
match_compensation_matches_away_team_id_idx UNUSED 1.28 MB
standings_stages_external_id_key 1.23 MB
match_compensation_matches_competition_id_idx 1.17 MB
live_standings_stages 1.08 MB
notified_mvps_match_id_key 1.02 MB
seasons_external_year_idx 1.02 MB
live_standings_promotions 1010 KB
match_compensation_companies 1010 KB
corrupted_matches 1000 KB
matches_live_match_time_idx 1000 KB
standings_stages_stage_id_idx 1000 KB
corrupted_matches_pkey 976 KB
update_times 968 KB
live_standings_stages_pkey 960 KB
season_league_unique_idx 824 KB
team_coaches_coach_season_team_unique 816 KB
live_standings 800 KB
match_compensations_pkey 800 KB
teams_coach_id_idx 768 KB
players_market_value_idx 760 KB
match_expected_goals_match_id_key 736 KB
seasons_external_id_key 672 KB
referees_name_ft_idx UNUSED 632 KB
unique_incident_related_incident 616 KB
venues_external_id_key 608 KB
team_market_values 584 KB
unique_seasons_idx 576 KB
match_compensations_match_id_unique_idx 560 KB
notified_mvps_pkey 560 KB
match_compensation_companies_pkey 448 KB
match_expected_goals_pkey 408 KB
related_incidents_pkey 408 KB
seasons_uid_idx 392 KB
leagues_name_ft_idx UNUSED 384 KB
team_coaches_pkey 376 KB
league_title_holders 336 KB
referees_external_id_key 296 KB
match_compensation_companies_unique_idx 240 KB
team_market_values_pkey 240 KB
live_standings_promotions_pkey 216 KB
league_title_holder_league_id_team_id_unique_idx 208 KB
live_standings_pkey 208 KB
season_league_current_season_idx 200 KB
countries 192 KB
standings_promotions_pkey 176 KB
leagues_external_id_key 152 KB
league_market_values 120 KB
league_title_holders_pkey 112 KB
idx_seasons_external_id_current 104 KB
injury_reasons 104 KB
idx_team_market_values_total 96 KB
league_fixture_priorities 88 KB
live_standings_stages_external_id_key 88 KB
live_standings_stages_stage_id_idx 88 KB
countries_name_ft_idx UNUSED 80 KB
leagues_category_id_idx 72 KB
updated_season_players_pkey 72 KB
updated_season_teams_pkey 72 KB
updated_season_teams_season_id_key 72 KB
flyway_football_schema_history 64 KB
updated_season_players 64 KB
updated_season_players_season_id_key 64 KB
live_standings_season_id_key 56 KB
notification_templates 56 KB
notification_var_labels 56 KB
standings_promotions_external_id_key 56 KB
updated_season_teams 56 KB
categories 48 KB
categories_name_ft_idx UNUSED 48 KB
custom_league_season 48 KB
data_update_types 48 KB
event_reasons 48 KB
halftime_statistics 48 KB
league_centers_per_league 48 KB
league_coeficiants_per_league 48 KB
league_fixture_secondary_priorities 48 KB
league_market_values_pkey 48 KB
leagues_deleted_idx 48 KB
lineup_locks 48 KB
match_statuses 48 KB
odds_companies 48 KB
technical_statistics 48 KB
idx_league_market_values_total 40 KB
injury_reasons_pkey 40 KB
league_coeficiants 40 KB
league_fixture_priorities_user_country_id_unique 40 KB
suggested_teams 40 KB
update_controller 40 KB
update_times_pkey 40 KB
update_times_update_type_unique_idx 40 KB
countries_external_id_key 32 KB
countries_pkey 32 KB
league_fixture_priorities_pkey 32 KB
categories_external_id_key 16 KB
categories_pkey 16 KB
countries_category_id_idx 16 KB
custom_league_season_league_id_key 16 KB
custom_league_season_pkey 16 KB
data_update_types_pkey 16 KB
event_reasons_pkey 16 KB
featured_leagues 16 KB
featured_leagues_league_id_key 16 KB
featured_leagues_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_centers_per_league_pkey 16 KB
league_coef 16 KB
league_coef_home 16 KB
league_coeficiants_per_league_pkey 16 KB
league_coeficiants_pkey 16 KB
league_fixture_priority_secondary_priorities_pkey 16 KB
league_fixture_secondary_priorities_user_country_id_unique 16 KB
lineup_locks_pkey 16 KB
live_standings_promotions_external_id_key 16 KB
match_statuses_pkey 16 KB
notification_templates_pkey 16 KB
notification_var_labels_pkey 16 KB
odds_companies_pkey 16 KB
ranking_leagues 16 KB
ranking_leagues_league_key 16 KB
ranking_leagues_pkey 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
black_listed_leagues 8 KB
black_listed_leagues_league_id_key 8 KB
black_listed_leagues_pkey 8 KB
idx_match_status_tracker_match_id UNUSED 8 KB
match_status_tracker_changed_at_match_id_new_status_id_idx 8 KB
match_status_tracker_pkey 8 KB
match_status_tracker 0 Bytes