PostgreSQL DBA

Monitoring & Diagnostics

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.

This is 11 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples