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
13,804,665Database records
226,156,361Database observations
0Source cache
21.0 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 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.