Runtime status

DB Index Status

boot-time index diagnostics for the current service process.

Enabledtrue

Checked9

Existing7

Missing2

Generated at2026-06-15T15:30:31Z

JSON endpoint/api/db-indexes/status

JSON recheck/api/db-indexes/recheck

Status	Table	Index name	Columns
existing	`opmetdata`	`idx_opmetdata_type_processed_msg_window`	`type, processed, msg_date_from, msg_date_to`
existing	`opmetdata`	`idx_opmetdata_processed_type_id`	`processed, type, id`
existing	`sigmet_geo`	`idx_sigmet_geo_opmetdata_id`	`opmetdata_id`
existing	`airmet_geo`	`idx_airmet_geo_opmetdata_id`	`opmetdata_id`
existing	`gamet_geo`	`idx_gamet_geo_opmetdata_id`	`opmetdata_id`
missing	`roshydro_grib_work`	`idx_roshydro_grib_work_parameter_forecast_level`	`parameter, forecast_seconds, level`
missing	`noaa_grib_work`	`idx_noaa_grib_work_parameter_forecast_level`	`parameter, forecast_seconds, level`
existing	`grib_noaa_files`	`idx_grib_noaa_files_run_date_cycle`	`#<Sequel::SQL::OrderedExpression:0x0000717cbbd58d48>, #<Sequel::SQL::OrderedExpression:0x0000717cbbd58cd0>`
existing	`grib_ftp_files`	`idx_grib_ftp_files_run_date_cycle`	`#<Sequel::SQL::OrderedExpression:0x0000717cbbd63b58>, #<Sequel::SQL::OrderedExpression:0x0000717cbbd63ae0>`