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.

DELETEJournal mode
15,823,285Database records
259,114,946Database observations
0Source cache
28.2 sDatabase read/write time

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 2.607 s · sources 180.558 s · database 28.229 s · reports 8.149 s · total 248.392 s.

CPU time 72.250 s · estimated share of total logical CPU capacity 0.00% · process priority normal-single-thread.