PgHealth is the ultimate open-source PostgreSQL database health check utility.
It checks PostgreSQL settings, configs and Linux postgres-related environmentwith series of checks.
The observed data is saved in the form of JSON reports, ready to be consumed by machines.
The final reports are .md files, in Markdown format, to be read by humans.
The main goal is to detect bottlenecks and prevent performance degradation.
It also helps to detect a lot of issues with postgres instances.
Let's make a report for a project namedmy-site_org-slony:Clusterslony contains two servers -db1 anddb2.PgHealth automatically detects which one is a master:
./check -h db1 -p 5432 --username postgres --dbname postgres --project my-site_org-slony
./check -h db2 -p 5432 --username postgres --dbname postgres --project my-site_org-slony -e 1
Which literally means: "connect to the server with given credentials, save data intomy-site_org-slonyproject directory as epoch of check1. Epoch is a numerical sign of current iteration.For example: in half a year we can switch to "epoch number2".
At the first run we can skip-e 1 because default epoch is1, but at the second argument-e
must exist: we don't want to overwrite historical results.
As a result of health-check we have got two directories with .json files and .md files:
./artifacts/my-site_org-slony/json_reports/1_2018_12_06T14_12_36_+0300/./artifacts/my-site_org-slony/md_reports/1_2018_12_06T14_12_36_+0300/
Each of generated files contains information about "what we check" and collected data forall instances of the postgres clustermy-site_org-slony.
Human-readable report can be found at:
./artifacts/my-site_org-slony/e1_full_report.md
Open it with your favorite Markdown files viewer or just upload to a service such as gist.github.com.
- bash
- psql
- coreutils
- jq >= 1.5
- golang >= 1.8
- awk
- sed