Runtime status

DB Index Status

boot-time index check summary for the current service process.

Enabledtrue

Checked9

Created0

Existing0

Missing9

Generated at2026-04-06T14:47:57Z

JSON endpoint/api/db-indexes/status

JSON recheck/api/db-indexes/recheck

Status	Table	Index name	Columns
missing	`opmetdata`	`idx_opmetdata_type_processed_msg_window`	`type, processed, msg_date_from, msg_date_to`
missing	`opmetdata`	`idx_opmetdata_processed_type_id`	`processed, type, id`
missing	`sigmet_geo`	`idx_sigmet_geo_opmetdata_id`	`opmetdata_id`
missing	`airmet_geo`	`idx_airmet_geo_opmetdata_id`	`opmetdata_id`
missing	`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`
missing	`grib_noaa_files`	`idx_grib_noaa_files_run_date_cycle`	`#<Sequel::SQL::OrderedExpression:0x000073538d0f9188>, #<Sequel::SQL::OrderedExpression:0x000073538d0f8aa8>`
missing	`grib_ftp_files`	`idx_grib_ftp_files_run_date_cycle`	`#<Sequel::SQL::OrderedExpression:0x000073538cfe45b8>, #<Sequel::SQL::OrderedExpression:0x000073538cfe44c8>`