Skip to content

PG Monitoring review Query analysis, physical level

Related to the current monitoring we need to review:

  • Query analysis, physical level – CPU and filesystem – based on pg_stat_kcache
    • Top-N by number of bytes read/written to disk
    • Top-N by user and system CPU time
    • Top-N by voluntary and involuntary context switches
    • Top-N by page reclaims and page faults

Acceptance criteria:

  • Fix the metrics and the dashboard
Edited by Jose Finotto