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 1.520 s · sources 61.559 s · database 21.049 s · reports 6.939 s · total 112.824 s.
CPU time 67.141 s · estimated share of total logical CPU capacity 0.00% · process priority normal-single-thread.