A walk through of monitoring PostgreSQL database clusters to include:
- Relevant PostgreSQL system catalog metrics
- Relevant contribs / extensions
- PostgreSQL log parsers
- PostgreSQL performance troubleshooting
- Performance tuning methods
Speaker works at
Consistent State
- Leverage your logs, monitor the logs
- Log all the queries that take longer than x seconds
- ps
- iostat
- netstat
- pgbadger
- pgtool
- PgPool
- Pg Monitor