In-Depth PostgreSQL Monitoring

Measure and track every aspect of your PostgreSQL databases

pgDash is a comprehensive monitoring solution designed specifically for PostgreSQL deployments. pgDash shows you information and metrics about every aspect of your PostgreSQL database server, collected using the open-source tool pgmetrics.


SaaS and self-hosted/on-premise options available.


How It Works

1
Collect PostgreSQL data, in JSON format, using our open-source tool pgmetrics.
2
Send it to pgDash regularly, using the pgdash command-line tool.
$ pgmetrics -f json -h myserver db1 db2
$ pgmetrics -f json -h myserver db1 db2 |
    pgdash -a myapikey report myserver

Features

Tables & Indexes

pgDash Tables and Indexes

pgDash shows you information about each table and index, like size, bloat, activity, vacuum and analyze information, cache efficiency and more.

Backends

pgDash Backends

Track backends waiting on locks, transactions that have been open too long, idling transactions. Filter and search through the list of backends.

System Information

pgDash System Information

Load average, memory usage, swap usage, and tablespace-wise disk usage can also be collected and monitored.

Replication

pgDash Replication

Monitor extensive replication metrics, including lags at primary and standby servers, physical and logical replication slot information, and standby recovery progress.

Queries

pgDash Queries

Interactively filter and browse slow SQL query information collected from the pg_stat_statements extension. Identify queries that run slow, cause too much disk activity or are cache-inefficient.

Alerting

pgDash Alerts

Set meaningful alerts, like “Commit Ratio of mydb is less than 80%”, “Number of backends waiting on locks is greater than 30”. Check on every report, send notifications via email, Slack or PagerDuty.

And More

WAL archiving information, BG Writer stats, vaccum progress information, roles including group membership, configuration settings. On-premise option so you can run pgDash yourself if you prefer. Coming Soon: Setup teams to share your pgDash metrics with your project members.


Try pgDash Today!


Signup

14-day free trial — no credit card required