About pgDash

RL
RL
Last updated 5 months ago

Overview

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.

pgDash is a product from RapidLoop, the makers of OpsDash.

Collecting Metrics

pgDash relies on pgmetrics for collecting metrics from Postgres servers. pgmetrics is an open-source, standalone utility which is useful in it’s own right (it can generate text reports like this).

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.

Sending Metrics to pgDash

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

Monitoring with pgDash

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 Availability

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 hello@rapidloop.com.