Postgres Monitoring Script Available

I wrote a small performance monitoring script for Postgres during the Super Bowl on Sunday called pg_glance.

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:

  1. Download to your ~/.ssh directory
  2. update the hosts variable with a space-separated list of postgres servers to monitor
  3. if you don’t have passwords on the linux postgres account, just run:
    watch -n 15 "./ | grep ':: '"

If you’re monitoring localhost, or using passwords with your postgres login, then you’ll need to spend a minute customizing the script.

This entry was posted in Postgresql, Tech. Bookmark the permalink.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.