PostgreSQL Health Check Script

PostgreSQL Health Check script is a simple scripts that provide PostgreSQL and OS metrics, connection status.


Idea is to automate daily DBA routine checks and see what’s going on on PostgreSQL servers without having to log in and enter same commands manually day-by-day. postgresql-monitoring-hero1


This script also allows you to collect most of the available PostgreSQL performance counters, OS & PostgreSQL configuration and database  details. 

Usage and download

This tool can run from shell or send a report via email (good for cron). Please feel free to download this tool from Github

Sample Report :

PostgresQLhealth

psotgresqlhealth1

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Powered by WordPress.com.

Up ↑

%d bloggers like this: