Database & performance
Storage model, runtime, and verified query plans.
About this view
What you see and why: This technical view describes the website database, retained records, indexes and measured processing times.
How to read it: Timing and CPU values describe the recorded processing run, not a live system monitor. The website database is separate from the shared daily OBS80 archive.
Safety
No WAL: journal_mode=DELETE, WAL sidecar: False, SHM sidecar: False.
Indexes
idx_observations_run_record, idx_observations_run_station_record, idx_records_run_category, idx_records_run_neocp
Object lookup: SEARCH records USING INDEX idx_records_run_neocp (run_id=? AND neocp=?)
Station lookup: SEARCH observations USING INDEX idx_observations_run_station_record (run_id=? AND station=?)
Runtime and CPU
Parsing 0.840 s · sources 205.553 s · database 18.026 s · reports 5.477 s · total 246.935 s.
CPU time 31.781 s · estimated share of total logical CPU capacity 3.22% · process priority normal-single-thread.