Monitoring & troubleshooting
Tools and techniques for monitoring PostgreSQL and solving common problems.
Guides by category​
System monitoring​
Track database health, performance metrics, and resource usage.
- How to troubleshoot Postgres performance using FlameGraphs and eBPF (or perf) - 6 min (beginner)
- How to determine the replication lag - 5 min (intermediate)
Lock analysis​
Understand and resolve locking issues and deadlocks.
Troubleshooting​
Diagnose and fix common PostgreSQL problems.
- How to flush caches (OS page cache and Postgres buffer pool) - 5 min
- How to NOT get screwed as a DBA (DBRE) - 5 min (beginner)