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.
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 :