Monitoring & Diagnostics of PostgreSQL
Mahadevan RAMACHANDRAN is the co-founder and CEO of RapidLoop, Inc. He drives the development of RapidLoop’s monitoring solutions, including pgDash and is the author of popular open source tools including pgmetrics, an open source PostgreSQL metrics collection tool. Mahadevan has 20 years of experience in the software industry. He has served as game CTO for top Zynga titles reaching millions of players and led development teams at Siemens, Philips, Emulex and EMC.
No video of the event yet, sorry!
The PostgreSQL server consists of several complex subsystems, each of which need to be monitored and tuned to maintain optimal health and performance. This presentation walks you through the monitoring of all important aspects of your PostgreSQL deployment, highlighting what to monitor, how to monitor and why to monitor each of them:
- backend activity
- wal files: archiving, growth
- vacuum progress and impact
- tablespaces and disk usage
- indexes: efficiency, size, bloat
- tables: growth, modifications
- logical and streaming replication
- locks and blocked queries
- background writer
The usage of the open source tool pgmetrics to aid this effort is demonstrated.
- 20 min
- Postgres Conference 2020
- Ops and Administration