I wrote a small performance monitoring script for Postgres during the Super Bowl on Sunday called
You can download it from my github project pg_glance.
Getting Started with pg_glance
It’s easy to get started …
If you’re remotely monitoring postgres instances using ssh keys to login from your notebook or application server:
- Download pg_glance.sh to your ~/.ssh directory
- update the hosts variable with a space-separated list of postgres servers to monitor
- if you don’t have passwords on the linux postgres account, just run:
watch -n 15 "./pg_glance.sh | grep ':: '"
If you’re monitoring localhost, or using passwords with your postgres login, then you’ll need to spend a minute customizing the script.