Question
Cumulative statistics versus dynamic activity: what differs, and when should each lead diagnosis?
Answer
Cumulative statistics aggregate counters since reset; dynamic activity shows current backend state and command context. Use cumulative views for trends and workload ranking; use pg_stat_activity and wait events for live stalls.