We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Database status
Live introspection of the shared Postgres dev DB — sizes, scan stats, connection load and derived performance bottlenecks.
Data providers (11)
| Provider | Domain | Status | Last run | Last success | Note |
|---|---|---|---|---|---|
| Betfair account (auto sign-in) | platform | healthy | 15m ago | 15m ago | AU interactive login · auto-refresh |
| Betfair multi-sport archive | platform | healthy | 1m ago | 1m ago | — |
| PuntAPI (GH) | racing | idle | never | never | — |
| Racing.com (TB) | racing | healthy | 22h ago | 22h ago | — |
| Racing QLD API | racing | idle | never | never | — |
| Racing QLD open data | racing | idle | never | never | — |
| The Dogs (GH) | racing | healthy | 23h ago | 23h ago | — |
| GRV Watchdog (GH) | racing | healthy | 23h ago | 23h ago | — |
| Results (martj42 diff) | football | healthy | 14m ago | 14m ago | — |
| World Cup 2026 fixtures | football | healthy | 29m ago | 29m ago | — |
| Historical odds | football | healthy | 29m ago | 29m ago | — |
8.1 GB
Database size
12 / 100
Connections
1 active · 11 idle
91.0%
Cache hit
heap blocks served from cache
79
Tables
204
Indexes
Performance bottlenecks (9)
warning
Low cache hit ratio
Heap cache hit ratio is 91.0% (target ≥ 99.0%). The working set may exceed shared buffers.
info
Unused index racing_historical_runner_starts_canonical_participant_id_start_
162.7 MB on racing_historical_runner_starts, never scanned. Adds write overhead with no read benefit — consider dropping it.
info
Unused index racing_hrs_sweep_idx
48.2 MB on racing_historical_runner_starts, never scanned. Adds write overhead with no read benefit — consider dropping it.
info
Unused index racing_historical_runner_starts_canonical_race_id_index
34.4 MB on racing_historical_runner_starts, never scanned. Adds write overhead with no read benefit — consider dropping it.
info
Unused index market_odds_bet_option_home_canon_away_canon_match_date_index
28.5 MB on market_odds, never scanned. Adds write overhead with no read benefit — consider dropping it.
info
Unused index odds_quotes_bookmaker_index
4.4 MB on odds_quotes, never scanned. Adds write overhead with no read benefit — consider dropping it.
info
Unused index racing_participants_participant_name_norm_index
3.2 MB on racing_participants, never scanned. Adds write overhead with no read benefit — consider dropping it.
info
Unused index matches_date_index
1.4 MB on matches, never scanned. Adds write overhead with no read benefit — consider dropping it.
info
Unused index racing_stewards_incidents_canonical_participant_id_meeting_date
1.1 MB on racing_stewards_incidents, never scanned. Adds write overhead with no read benefit — consider dropping it.
Tables
| Table | Rows (est) | Total | Table | Indexes | Seq scans | Idx scans | Dead | Vacuumed |
|---|---|---|---|---|---|---|---|---|
| racing_sectionals | 5,382,626 | 2.3 GB | 1.3 GB | 1.0 GB | 7 | 4 | 0 (0.0%) | 33m ago |
| racing_historical_runner_starts | 3,375,764 | 1.6 GB | 950.2 MB | 663.5 MB | 13 | 0 | 0 (0.0%) | 35m ago |
| market_odds | 3,880,956 | 1.5 GB | 827.3 MB | 658.5 MB | 10 | 0 | 0 (0.0%) | 36m ago |
| racing_race_entries | 2,101,173 | 943.1 MB | 694.5 MB | 248.6 MB | 7 | 30 | 0 (0.0%) | 34m ago |
| racing_results | 2,045,896 | 726.9 MB | 484.8 MB | 242.1 MB | 7 | 30 | 0 (0.0%) | 34m ago |
| racing_races | 276,491 | 399.5 MB | 370.5 MB | 29.0 MB | 73 | 384 | 0 (0.0%) | 35m ago |
| racing_raw_payloads | 11,791 | 356.9 MB | 355.9 MB | 1.0 MB | 8 | 0 | 0 (0.0%) | 35m ago |
| odds_quotes | 651,918 | 225.1 MB | 141.1 MB | 84.1 MB | 47 | 312,154 | 0 (0.0%) | 36m ago |
| racing_participants | 104,989 | 47.0 MB | 36.3 MB | 10.7 MB | 10 | 15 | 0 (0.0%) | 36m ago |
| canonical_matches | 52,008 | 35.1 MB | 24.8 MB | 10.4 MB | 26 | 161,851 | 0 (0.0%) | 14m ago |
| matches | 53,224 | 25.1 MB | 14.0 MB | 11.1 MB | 14 | 99,108 | 2,481 (4.5%) | 14m ago |
| odds_btts | 64,778 | 21.5 MB | 13.5 MB | 8.0 MB | 9 | 1 | 0 (0.0%) | 36m ago |
| odds_requests | 4,501 | 17.8 MB | 17.1 MB | 736.0 KB | 8 | 10 | 0 (0.0%) | 36m ago |
| racing_stewards_incidents | 17,396 | 10.3 MB | 7.2 MB | 3.1 MB | 5 | 3 | 0 (0.0%) | 34m ago |
| racing_meetings | 25,976 | 9.9 MB | 7.6 MB | 2.3 MB | 5 | 147 | 0 (0.0%) | 36m ago |
| squad_values | 43,022 | 8.3 MB | 4.3 MB | 4.1 MB | 4 | 200 | 0 (0.0%) | 34m ago |
| odds_totals | 24,297 | 8.1 MB | 5.1 MB | 2.9 MB | 5 | 14 | 0 (0.0%) | 36m ago |
| racing_model_runs | 11 | 3.0 MB | 2.9 MB | 64.0 KB | 31 | 0 | 0 (0.0%) | never |
| nrl_odds | 7,523 | 2.7 MB | 1.4 MB | 1.3 MB | 4 | 0 | 0 (0.0%) | 36m ago |
| _hyper_4_1_chunk | 9,050 | 1.7 MB | 1.1 MB | 640.0 KB | 4 | 35 | 0 (0.0%) | 36m ago |
| match_lineups | 2,495 | 1.6 MB | 1.2 MB | 336.0 KB | 6 | 1 | 0 (0.0%) | 36m ago |
| match_stats | 3,559 | 1.3 MB | 904.0 KB | 456.0 KB | 7 | 3 | 0 (0.0%) | 36m ago |
| polymarket_markets | 145 | 1.3 MB | 1.2 MB | 48.0 KB | 7 | 0 | 0 (0.0%) | never |
| nrl_matches | 3,554 | 1.2 MB | 768.0 KB | 496.0 KB | 23 | 20 | 0 (0.0%) | 36m ago |
| oban_jobs | 1,023 | 912.0 KB | 608.0 KB | 304.0 KB | 9 | 5,276 | 172 (14.4%) | never |
| racing_stewards_reports | 927 | 480.0 KB | 352.0 KB | 128.0 KB | 5 | 2 | 0 (0.0%) | never |
| betfair_markets | 104 | 240.0 KB | 176.0 KB | 64.0 KB | 6 | 32 | 3 (2.8%) | never |
| trained_models | 4 | 192.0 KB | 144.0 KB | 48.0 KB | 10 | 0 | 0 (0.0%) | never |
| teams | 425 | 120.0 KB | 56.0 KB | 64.0 KB | 31 | 5,526 | 0 (0.0%) | never |
| bets | 9 | 112.0 KB | 16.0 KB | 96.0 KB | 21 | 0 | 0 (0.0%) | never |
| chunk | 1 | 104.0 KB | 8.0 KB | 96.0 KB | 8 | 6,467 | 0 (0.0%) | never |
| strategy_configs | 5 | 80.0 KB | 16.0 KB | 64.0 KB | 6 | 0 | 0 (0.0%) | never |
| oban_peers | 1 | 80.0 KB | 56.0 KB | 24.0 KB | 143 | 138 | 36 (97.3%) | 8m ago |
| bgw_job_stat_history | 1 | 64.0 KB | 16.0 KB | 48.0 KB | 4 | 1 | 0 (0.0%) | never |
| dimension_slice | 1 | 56.0 KB | 8.0 KB | 48.0 KB | 4 | 70 | 0 (0.0%) | never |
| hypertable | 8 | 56.0 KB | 8.0 KB | 48.0 KB | 24 | 972 | 4 (33.3%) | never |
| compression_settings | 4 | 48.0 KB | 16.0 KB | 32.0 KB | 6 | 1,075 | 16 (80.0%) | never |
| bracket_matches | 32 | 48.0 KB | 16.0 KB | 32.0 KB | 3 | 0 | 0 (0.0%) | never |
| settings | 6 | 48.0 KB | 16.0 KB | 32.0 KB | 513 | 0 | 0 (0.0%) | never |
| bgw_job | 6 | 48.0 KB | 16.0 KB | 32.0 KB | 3 | 32 | 0 (0.0%) | never |
| racing_bets | 0 | 40.0 KB | 8.0 KB | 32.0 KB | 5 | 1 | 0 (0.0%) | never |
| racing_betfair_orders | 0 | 40.0 KB | 8.0 KB | 32.0 KB | 6 | 0 | 0 (0.0%) | never |
| racing_predictions | 0 | 40.0 KB | 8.0 KB | 32.0 KB | 6 | 0 | 0 (0.0%) | never |
| dimension | 4 | 40.0 KB | 8.0 KB | 32.0 KB | 20 | 115 | 0 (0.0%) | never |
| racing_market_quotes | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| racing_track_weather_hourly | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| racing_prediction_runs | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| tournament_simulations | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| backtest_predictions | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 5 | 0 | 0 (0.0%) | never |
| backtest_runs | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 1 | 0 (0.0%) | never |
| betfair_orders | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| betfair_closing_lines | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| betfair_price_snapshots | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| compression_algorithm | 8 | 32.0 KB | 16.0 KB | 16.0 KB | 1 | 0 | 0 (0.0%) | never |
| continuous_agg | 0 | 32.0 KB | 0 B | 32.0 KB | 61 | 16 | 0 (0.0%) | never |
| metadata | 3 | 32.0 KB | 16.0 KB | 16.0 KB | 2 | 15 | 3 (50.0%) | never |
| racing_prices | 0 | 32.0 KB | 8.0 KB | 24.0 KB | 4 | 0 | 0 (0.0%) | never |
| bgw_job_stat | 2 | 24.0 KB | 8.0 KB | 16.0 KB | 1 | 16 | 7 (77.8%) | never |
| schema_migrations | 39 | 24.0 KB | 8.0 KB | 16.0 KB | 6 | 0 | 0 (0.0%) | never |
| racing_participant_identity_links | 0 | 24.0 KB | 8.0 KB | 16.0 KB | 4 | 0 | 0 (0.0%) | never |
| chunk_column_stats | 0 | 16.0 KB | 0 B | 16.0 KB | 3 | 0 | 0 (0.0%) | never |
| continuous_aggs_bucket_function | 0 | 16.0 KB | 8.0 KB | 8.0 KB | 2 | 0 | 0 (0.0%) | never |
| tablespace | 0 | 16.0 KB | 0 B | 16.0 KB | 3 | 0 | 0 (0.0%) | never |
| compression_chunk_size | 0 | 16.0 KB | 0 B | 16.0 KB | 3 | 0 | 0 (0.0%) | never |
| continuous_aggs_watermark | 0 | 8.0 KB | 0 B | 8.0 KB | 2 | 1 | 0 (0.0%) | never |
| continuous_aggs_hypertable_invalidation_log | 0 | 8.0 KB | 0 B | 8.0 KB | 2 | 0 | 0 (0.0%) | never |
| continuous_aggs_invalidation_threshold | 0 | 8.0 KB | 0 B | 8.0 KB | 2 | 0 | 0 (0.0%) | never |
| continuous_aggs_jobs_refresh_ranges | 0 | 8.0 KB | 0 B | 8.0 KB | 3 | 0 | 0 (0.0%) | never |
| continuous_aggs_materialization_invalidation_log | 0 | 8.0 KB | 0 B | 8.0 KB | 3 | 0 | 0 (0.0%) | never |
| continuous_aggs_materialization_ranges | 0 | 8.0 KB | 0 B | 8.0 KB | 3 | 0 | 0 (0.0%) | never |
| chunk_rewrite | 0 | 8.0 KB | 0 B | 8.0 KB | 1 | 0 | 0 (0.0%) | never |
| bgw_policy_chunk_stats | 0 | 8.0 KB | 0 B | 8.0 KB | 1 | 0 | 0 (0.0%) | never |
| cache_inval_bgw_job | 0 | 0 B | 0 B | 0 B | 0 | 0 | 0 (0.0%) | never |
| _compressed_hypertable_6 | 0 | 0 B | 0 B | 0 B | 1 | 0 | 0 (0.0%) | never |
| _compressed_hypertable_7 | 0 | 0 B | 0 B | 0 B | 1 | 0 | 0 (0.0%) | never |
| _compressed_hypertable_5 | 0 | 0 B | 0 B | 0 B | 1 | 0 | 0 (0.0%) | never |
| _compressed_hypertable_8 | 0 | 0 B | 0 B | 0 B | 1 | 0 | 0 (0.0%) | never |
| cache_inval_extension | 0 | 0 B | 0 B | 0 B | 0 | 0 | 0 (0.0%) | never |
| cache_inval_hypertable | 0 | 0 B | 0 B | 0 B | 0 | 0 | 0 (0.0%) | never |
Indexes least-used first
| Index | Table | Scans | Size | Kind |
|---|---|---|---|---|
| racing_sectionals_pkey | racing_sectionals | 0 | 881.3 MB | primary |
| market_odds_book_prop_idx | market_odds | 0 | 547.0 MB | unique |
| racing_historical_runner_starts_pkey | racing_historical_runner_starts | 0 | 418.1 MB | primary |
| racing_historical_runner_starts_canonical_participant_id_start_ | racing_historical_runner_starts | 0 | 162.7 MB | index |
| market_odds_pkey | market_odds | 0 | 83.1 MB | primary |
| racing_hrs_sweep_idx | racing_historical_runner_starts | 0 | 48.2 MB | index |
| racing_historical_runner_starts_canonical_race_id_index | racing_historical_runner_starts | 0 | 34.4 MB | index |
| market_odds_bet_option_home_canon_away_canon_match_date_index | market_odds | 0 | 28.5 MB | index |
| odds_quotes_pkey | odds_quotes | 0 | 14.0 MB | primary |
| odds_quotes_bookmaker_index | odds_quotes | 0 | 4.4 MB | index |
| racing_participants_participant_name_norm_index | racing_participants | 0 | 3.2 MB | index |
| matches_pkey | matches | 0 | 2.2 MB | primary |
| squad_values_team_date_method_index | squad_values | 0 | 1.8 MB | unique |
| odds_btts_pkey | odds_btts | 0 | 1.4 MB | primary |
| matches_date_index | matches | 0 | 1.4 MB | index |
| racing_stewards_incidents_canonical_participant_id_meeting_date | racing_stewards_incidents | 0 | 1.1 MB | index |
| racing_stewards_incidents_pkey | racing_stewards_incidents | 0 | 1.1 MB | primary |
| nrl_odds_match_key_market_book_line_index | nrl_odds | 0 | 848.0 KB | unique |
| racing_raw_payloads_pkey | racing_raw_payloads | 0 | 808.0 KB | primary |
| racing_stewards_incidents_dog_name_norm_meeting_date_index | racing_stewards_incidents | 0 | 648.0 KB | index |
| odds_btts_bookmaker_sport_key_commence_time_index | odds_btts | 0 | 552.0 KB | index |
| odds_totals_pkey | odds_totals | 0 | 552.0 KB | primary |
| odds_btts_home_canon_away_canon_match_date_index | odds_btts | 0 | 528.0 KB | index |
| nrl_odds_match_key_index | nrl_odds | 0 | 272.0 KB | index |
| nrl_matches_match_key_index | nrl_matches | 0 | 264.0 KB | unique |
| racing_meetings_meeting_date_index | racing_meetings | 0 | 224.0 KB | index |
| racing_meetings_track_norm_index | racing_meetings | 0 | 208.0 KB | index |
| match_stats_source_ext_match_id_index | match_stats | 0 | 192.0 KB | unique |
| nrl_odds_pkey | nrl_odds | 0 | 184.0 KB | primary |
| match_lineups_source_ext_match_id_index | match_lineups | 0 | 144.0 KB | unique |
| match_lineups_home_canon_away_canon_match_date_index | match_lineups | 0 | 120.0 KB | index |
| racing_raw_payloads_ingested_at_utc_index | racing_raw_payloads | 0 | 112.0 KB | index |
| racing_raw_payloads_source_index | racing_raw_payloads | 0 | 104.0 KB | index |
| nrl_matches_pkey | nrl_matches | 0 | 96.0 KB | primary |
| oban_jobs_meta_index | oban_jobs | 0 | 64.0 KB | index |
| racing_stewards_reports_meeting_date_index | racing_stewards_reports | 0 | 32.0 KB | index |
| racing_model_runs_model_key_index | racing_model_runs | 0 | 16.0 KB | index |
| racing_model_runs_code_index | racing_model_runs | 0 | 16.0 KB | index |
| racing_model_runs_pkey | racing_model_runs | 0 | 16.0 KB | primary |
| hypertable_associated_schema_name_associated_table_prefix_key | hypertable | 0 | 16.0 KB | unique |
| bgw_job_stat_history_pkey | bgw_job_stat_history | 0 | 16.0 KB | primary |
| strategy_configs_position_index | strategy_configs | 0 | 16.0 KB | index |
| betfair_markets_event_type_id_index | betfair_markets | 0 | 16.0 KB | index |
| strategy_configs_name_index | strategy_configs | 0 | 16.0 KB | unique |
| polymarket_markets_pkey | polymarket_markets | 0 | 16.0 KB | primary |
| polymarket_markets_event_slug_index | polymarket_markets | 0 | 16.0 KB | unique |
| polymarket_markets_home_canon_away_canon_match_date_index | polymarket_markets | 0 | 16.0 KB | index |
| betfair_markets_status_index | betfair_markets | 0 | 16.0 KB | index |
| compression_algorithm_pkey | compression_algorithm | 0 | 16.0 KB | primary |
| chunk_hypertable_id_creation_time_idx | chunk | 0 | 16.0 KB | index |
| chunk_osm_chunk_idx | chunk | 0 | 16.0 KB | index |
| chunk_compressed_chunk_id_idx | chunk | 0 | 16.0 KB | index |
| strategy_configs_enabled_index | strategy_configs | 0 | 16.0 KB | index |
| bgw_job_stat_history_job_id_execution_start_idx | bgw_job_stat_history | 0 | 16.0 KB | index |
| bets_pkey | bets | 0 | 16.0 KB | primary |
| bets_home_away_match_date_index | bets | 0 | 16.0 KB | index |
| bets_market_index | bets | 0 | 16.0 KB | index |
| bets_match_id_index | bets | 0 | 16.0 KB | index |
| bets_status_index | bets | 0 | 16.0 KB | index |
| bets_strategy_config_id_index | bets | 0 | 16.0 KB | index |
| bracket_matches_pkey | bracket_matches | 0 | 16.0 KB | primary |
| bracket_matches_tournament_year_num_index | bracket_matches | 0 | 16.0 KB | unique |
| strategy_configs_pkey | strategy_configs | 0 | 16.0 KB | primary |
| trained_models_one_default | trained_models | 0 | 16.0 KB | unique |
| trained_models_name_index | trained_models | 0 | 16.0 KB | unique |
| trained_models_pkey | trained_models | 0 | 16.0 KB | primary |
| settings_key_index | settings | 0 | 16.0 KB | unique |
| settings_pkey | settings | 0 | 16.0 KB | primary |
| schema_migrations_pkey | schema_migrations | 0 | 16.0 KB | primary |
| racing_stewards_reports_track_norm_index | racing_stewards_reports | 0 | 16.0 KB | index |
| racing_model_runs_model_version_index | racing_model_runs | 0 | 16.0 KB | index |
| bgw_policy_chunk_stats_job_id_chunk_id_key | bgw_policy_chunk_stats | 0 | 8.0 KB | unique |
| betfair_price_snapshots_pkey | betfair_price_snapshots | 0 | 8.0 KB | primary |
| betfair_price_snapshots_market_id_selection_id_index | betfair_price_snapshots | 0 | 8.0 KB | index |
| betfair_price_snapshots_snapshot_at_idx | betfair_price_snapshots | 0 | 8.0 KB | index |
| betfair_closing_lines_pkey | betfair_closing_lines | 0 | 8.0 KB | primary |
| betfair_closing_lines_market_id_index | betfair_closing_lines | 0 | 8.0 KB | index |
| betfair_closing_lines_sport_key_market_start_time_index | betfair_closing_lines | 0 | 8.0 KB | index |
| betfair_orders_pkey | betfair_orders | 0 | 8.0 KB | primary |
| betfair_orders_customer_ref_index | betfair_orders | 0 | 8.0 KB | unique |
| betfair_orders_status_index | betfair_orders | 0 | 8.0 KB | index |
| backtest_runs_pkey | backtest_runs | 0 | 8.0 KB | primary |
| backtest_runs_predictor_key_index | backtest_runs | 0 | 8.0 KB | index |
| racing_bets_pkey | racing_bets | 0 | 8.0 KB | primary |
| racing_bets_canonical_race_id_index | racing_bets | 0 | 8.0 KB | index |
| racing_bets_status_index | racing_bets | 0 | 8.0 KB | index |
| racing_participant_identity_links_pkey | racing_participant_identity_links | 0 | 8.0 KB | primary |
| racing_participant_identity_links_canonical_participant_id_inde | racing_participant_identity_links | 0 | 8.0 KB | index |
| racing_betfair_orders_pkey | racing_betfair_orders | 0 | 8.0 KB | primary |
| racing_betfair_orders_canonical_race_id_index | racing_betfair_orders | 0 | 8.0 KB | index |
| racing_betfair_orders_customer_ref_index | racing_betfair_orders | 0 | 8.0 KB | unique |
| racing_betfair_orders_status_index | racing_betfair_orders | 0 | 8.0 KB | index |
| racing_market_quotes_pkey | racing_market_quotes | 0 | 8.0 KB | primary |
| racing_market_quotes_canonical_race_id_canonical_participant_id | racing_market_quotes | 0 | 8.0 KB | index |
| racing_market_quotes_quote_time_utc_idx | racing_market_quotes | 0 | 8.0 KB | index |
| racing_prices_pkey | racing_prices | 0 | 8.0 KB | primary |
| racing_prices_canonical_race_id_canonical_participant_id_index | racing_prices | 0 | 8.0 KB | index |
| racing_prices_ingested_at_utc_idx | racing_prices | 0 | 8.0 KB | index |
| racing_track_weather_hourly_pkey | racing_track_weather_hourly | 0 | 8.0 KB | primary |
| racing_track_weather_hourly_start_time_utc_idx | racing_track_weather_hourly | 0 | 8.0 KB | index |
| racing_track_weather_hourly_track_norm_start_time_utc_index | racing_track_weather_hourly | 0 | 8.0 KB | index |
| racing_prediction_runs_pkey | racing_prediction_runs | 0 | 8.0 KB | primary |
| racing_prediction_runs_model_version_index | racing_prediction_runs | 0 | 8.0 KB | index |
| racing_prediction_runs_run_date_index | racing_prediction_runs | 0 | 8.0 KB | index |
| racing_predictions_pkey | racing_predictions | 0 | 8.0 KB | primary |
| racing_predictions_prediction_run_id_canonical_race_id_index | racing_predictions | 0 | 8.0 KB | index |
| racing_predictions_prediction_run_id_index | racing_predictions | 0 | 8.0 KB | index |
| racing_predictions_run_race_participant_index | racing_predictions | 0 | 8.0 KB | unique |
| tournament_simulations_pkey | tournament_simulations | 0 | 8.0 KB | primary |
| tournament_simulations_tournament_year_index | tournament_simulations | 0 | 8.0 KB | index |
| tournament_simulations_tournament_year_predictor_runs_seed_data | tournament_simulations | 0 | 8.0 KB | unique |
| backtest_predictions_pkey | backtest_predictions | 0 | 8.0 KB | primary |
| backtest_predictions_backtest_run_id_correct_index | backtest_predictions | 0 | 8.0 KB | index |
| backtest_predictions_backtest_run_id_index | backtest_predictions | 0 | 8.0 KB | index |
| chunk_column_stats_pkey | chunk_column_stats | 0 | 8.0 KB | primary |
| chunk_column_stats_ht_id_chunk_id_colname_key | chunk_column_stats | 0 | 8.0 KB | unique |
| chunk_rewrite_key | chunk_rewrite | 0 | 8.0 KB | unique |
| compression_chunk_size_pkey | compression_chunk_size | 0 | 8.0 KB | primary |
| compression_chunk_size_idx | compression_chunk_size | 0 | 8.0 KB | index |
| continuous_agg_pkey | continuous_agg | 0 | 8.0 KB | primary |
| continuous_agg_partial_view_schema_partial_view_name_key | continuous_agg | 0 | 8.0 KB | unique |
| continuous_agg_user_view_schema_user_view_name_key | continuous_agg | 0 | 8.0 KB | unique |
| continuous_aggs_bucket_function_pkey | continuous_aggs_bucket_function | 0 | 8.0 KB | primary |
| continuous_aggs_hypertable_invalidation_log_idx | continuous_aggs_hypertable_invalidation_log | 0 | 8.0 KB | index |
| continuous_aggs_invalidation_threshold_pkey | continuous_aggs_invalidation_threshold | 0 | 8.0 KB | primary |
| continuous_aggs_jobs_refresh_ranges_idx | continuous_aggs_jobs_refresh_ranges | 0 | 8.0 KB | index |
| continuous_aggs_materialization_invalidation_log_idx | continuous_aggs_materialization_invalidation_log | 0 | 8.0 KB | index |
| continuous_aggs_materialization_ranges_idx | continuous_aggs_materialization_ranges | 0 | 8.0 KB | index |
| tablespace_pkey | tablespace | 0 | 8.0 KB | primary |
| tablespace_hypertable_id_tablespace_name_key | tablespace | 0 | 8.0 KB | unique |
| odds_btts_odds_request_id_event_id_bookmaker_index | odds_btts | 1 | 5.5 MB | unique |
| odds_quotes_bookmaker_sport_key_commence_time_index | odds_quotes | 1 | 4.9 MB | index |
| squad_values_pkey | squad_values | 1 | 960.0 KB | primary |
| odds_totals_home_canon_away_canon_match_date_index | odds_totals | 1 | 224.0 KB | index |
| _hyper_4_1_chunk_betfair_price_snapshots_market_id_selection_id | _hyper_4_1_chunk | 1 | 104.0 KB | index |
| match_stats_pkey | match_stats | 1 | 96.0 KB | primary |
| match_lineups_pkey | match_lineups | 1 | 72.0 KB | primary |
| bgw_job_stat_history_execution_start_idx | bgw_job_stat_history | 1 | 16.0 KB | index |
| dimension_slice_pkey | dimension_slice | 1 | 16.0 KB | primary |
| racing_bets_prediction_run_id_index | racing_bets | 1 | 8.0 KB | index |
| continuous_aggs_watermark_pkey | continuous_aggs_watermark | 1 | 8.0 KB | primary |
| backtest_runs_inserted_at_index | backtest_runs | 1 | 8.0 KB | index |
| odds_quotes_polymarket_idx | odds_quotes | 2 | 4.8 MB | unique |
| canonical_matches_date_home_team_id_away_team_id_index | canonical_matches | 2 | 4.0 MB | unique |
| matches_status_index | matches | 2 | 856.0 KB | index |
| match_stats_home_canon_away_canon_match_date_index | match_stats | 2 | 168.0 KB | index |
| _hyper_4_1_chunk_betfair_price_snapshots_snapshot_at_idx | _hyper_4_1_chunk | 2 | 80.0 KB | index |
| racing_stewards_reports_pkey | racing_stewards_reports | 2 | 80.0 KB | primary |
| racing_stewards_incidents_report_id_index | racing_stewards_incidents | 3 | 192.0 KB | index |
| racing_sectionals_canonical_race_id_canonical_participant_id_in | racing_sectionals | 4 | 186.5 MB | index |
| odds_quotes_odds_request_id_event_id_bookmaker_index | odds_quotes | 4 | 51.3 MB | unique |
| matches_source_index | matches | 4 | 840.0 KB | index |
| odds_requests_cache_key_index | odds_requests | 4 | 616.0 KB | unique |
| chunk_hypertable_id_idx | chunk | 4 | 16.0 KB | index |
| odds_totals_odds_request_id_event_id_bookmaker_point_index | odds_totals | 5 | 1.9 MB | unique |
| racing_participants_code_index | racing_participants | 6 | 728.0 KB | index |
| odds_requests_pkey | odds_requests | 6 | 120.0 KB | primary |
| nrl_matches_season_round_index | nrl_matches | 6 | 40.0 KB | index |
| odds_totals_bookmaker_sport_key_commence_time_index | odds_totals | 8 | 272.0 KB | index |
| racing_race_entries_canonical_participant_id_index | racing_race_entries | 9 | 19.9 MB | index |
| racing_results_canonical_participant_id_index | racing_results | 9 | 19.5 MB | index |
| racing_participants_pkey | racing_participants | 9 | 6.8 MB | primary |
| canonical_matches_is_world_cup_index | canonical_matches | 11 | 1.1 MB | index |
| racing_races_code_index | racing_races | 12 | 1.9 MB | index |
| racing_meetings_code_index | racing_meetings | 12 | 192.0 KB | index |
| canonical_matches_status_index | canonical_matches | 14 | 1.1 MB | index |
| nrl_matches_kickoff_utc_index | nrl_matches | 14 | 96.0 KB | index |
| metadata_pkey | metadata | 15 | 16.0 KB | primary |
| bgw_job_stat_pkey | bgw_job_stat | 16 | 16.0 KB | primary |
| betfair_markets_pkey | betfair_markets | 16 | 16.0 KB | primary |
| bgw_job_pkey | bgw_job | 16 | 16.0 KB | primary |
| bgw_job_proc_hypertable_id_idx | bgw_job | 16 | 16.0 KB | index |
| betfair_markets_sport_key_market_start_time_index | betfair_markets | 16 | 16.0 KB | index |
| continuous_agg_raw_hypertable_id_idx | continuous_agg | 16 | 8.0 KB | index |
| dimension_pkey | dimension | 18 | 16.0 KB | primary |
| dimension_slice_dimension_id_range_start_range_end_idx | dimension_slice | 18 | 16.0 KB | index |
| racing_race_entries_canonical_race_id_canonical_participant_id_ | racing_race_entries | 21 | 228.8 MB | unique |
| racing_results_pkey | racing_results | 21 | 222.6 MB | primary |
| chunk_pkey | chunk | 25 | 16.0 KB | primary |
| 1_betfair_price_snapshots_pkey | _hyper_4_1_chunk | 32 | 456.0 KB | primary |
| oban_jobs_args_index | oban_jobs | 32 | 24.0 KB | index |
| racing_races_pkey | racing_races | 33 | 17.9 MB | primary |
| compression_settings_pkey | compression_settings | 36 | 16.0 KB | primary |
| dimension_slice_chunk_id_dimension_id_key | dimension_slice | 51 | 16.0 KB | unique |
| oban_jobs_state_discarded_at_index | oban_jobs | 64 | 40.0 KB | index |
| canonical_matches_date_index | canonical_matches | 73 | 1.8 MB | index |
| dimension_hypertable_id_column_name_key | dimension | 97 | 16.0 KB | unique |
| hypertable_pkey | hypertable | 115 | 16.0 KB | primary |
| racing_races_canonical_meeting_id_index | racing_races | 135 | 3.5 MB | index |
| racing_meetings_pkey | racing_meetings | 135 | 1.7 MB | primary |
| oban_peers_pkey | oban_peers | 138 | 16.0 KB | primary |
| squad_values_team_date_index | squad_values | 199 | 1.4 MB | index |
| racing_races_scheduled_off_utc_index | racing_races | 204 | 5.7 MB | index |
| teams_name_index | teams | 728 | 32.0 KB | unique |
| hypertable_table_name_schema_name_key | hypertable | 861 | 16.0 KB | unique |
| compression_settings_compress_relid_idx | compression_settings | 1,039 | 16.0 KB | index |
| oban_jobs_pkey | oban_jobs | 1,048 | 40.0 KB | primary |
| oban_jobs_state_queue_priority_scheduled_at_id_index | oban_jobs | 2,049 | 72.0 KB | index |
| oban_jobs_state_cancelled_at_index | oban_jobs | 2,083 | 16.0 KB | index |
| teams_pkey | teams | 4,798 | 32.0 KB | primary |
| chunk_schema_name_table_name_key | chunk | 6,450 | 16.0 KB | unique |
| matches_date_home_team_id_away_team_id_source_index | matches | 99,102 | 5.9 MB | unique |
| canonical_matches_pkey | canonical_matches | 161,751 | 2.2 MB | primary |
| odds_quotes_home_canon_away_canon_match_date_index | odds_quotes | 312,149 | 4.6 MB | index |
Slowest queries
pg_stat_statements is not enabled on this
database, so per-query timings are unavailable. Enable the extension to populate this section.