pgDash lets you observe and track every aspect of your PostgreSQL database servers. pgDash provides core reporting and visualization functionality, including collecting and displaying PostgreSQL information and providing time-series graphs and detailed reports as well as alerting.
pgmetrics is a single, zero-dependency binary with a command-line syntax similar to psql. It can emit the data it collects either as a textual report, or as JSON. The JSON output can be used for scripting, and in this case, can be sent to pgDash. See pgmetrics.io for more information.
pgDash has a REST-like HTTP API, by which reports generated by pgmetrics can be uploaded to pgDash. There is an open-source command-line utility, available here, which provides a simpler way to access this API.
All said, collecting and sending metrics to pgDash is as simple as:
$ pgmetrics -h myserver -f json mydb1 mydb2 |pgdash -a APIKEY report my-prod-dbs
Once you’ve set up regular collection of metrics, you can view detailed statistics and trends in pgDash. Timeseries metric data extracted from each uploaded report is stored and retained. Graphs based on these metrics are presented alongside the latest report to easily visualize trends and detect anomalies.
You can easily set alerts like "warn if number of backends waiting for locks is more than 10", "critical if time since last checkpoint is greater than 5 minutes". Alerts can be notified by email, Slack and PagerDuty.
pgDash is available both as a SaaS product, at https://pgdash.io, and as a self-hosted (on-premise) version that you can host yourself. For more details about the self-hosted version, please contact us at firstname.lastname@example.org.