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