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