Monitoring

Monitor database performance, analyze statistics, and track system metrics

How-to guides

How to work with pg_stat_statements, part 1

Difficulty: beginner • Time: 8 min

Ad-hoc monitoring

Difficulty: beginner • Time: 7 min

How to monitor transaction ID wraparound risks

Difficulty: advanced • Time: 5 min

How to monitor xmin horizon to prevent XID/MultiXID wraparound and high bloat

Difficulty: intermediate • Time: 6 min

How to analyze heavyweight locks, part 1

Difficulty: beginner • Time: 5 min

How to reduce WAL generation rates

Difficulty: intermediate • Time: 5 min