In-Depth PostgreSQL Monitoring

pgDash is a comprehensive diagnostic and monitoring solution designed to help you ensure the ongoing health and performance of your PostgreSQL deployment.

pgDash provides core reporting and visualization functionality, including collecting and displaying PostgreSQL information and providing diagnostics, time-series graphs, detailed reports, alerting, teams and more. SaaS and self-hosted/on-premise options available.

“We've found pgDash to be an indispensable tool for monitoring and for understanding how our Postgres system is scaling. Since integrating it into our tooling, we've been able to make smarter decisions about where indexes are needed, and have been able to more easily tune our database for performance. If you run Postgres in production, particularly on RDS, I highly recommend it.”

— Reuben Firmin, CTO, ExecVision


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.

Locks & Backends

pgDash Backends

See which queries and waiting for which others. Track backends waiting on locks, transactions that have been open too long, idling transactions.

System Information

pgDash System Information

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

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.

Diagnostics

pgDash Diagnostics

Diagnostics examines your PostgreSQL server and databases scanning for potential issues that can impact the health and performance of the deployment.

Replication

pgDash Replication

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

Teams

pgDash lets you share all the data for a server with your team members. The team member you're sharing it with can view all information, metrics and graphs, but will not be able to delete any server data. Team sharing is available in the Pro and Enterprise versions of pgDash SaaS and self-hosted / on-premise.

Alerting

pgDash Basic Alerting lets you set meaningful alerts, like “Commit Ratio of mydb is less than 80%”, “Number of backends waiting on locks is greater than 30”, and get notificatied via email, Slack or PagerDuty. Change Alerts automatically inform you about important changes to your PostgreSQL databases, like addition or deletion of users, tables, indexes, or abrupt increases or decreases in table size, and more. Change Alerts are available in the Pro and Enterprise versions of pgDash SaaS and self-hosted / on-premise.

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.


“pgDash has been a welcome addition to our PostgreSQL toolkit. With pgDash we are able to quickly discover and diagnose issues with our deployment. pgDash was easy to setup and has been working very well for us.”

— Jean-Yves Sireau, Founder, Binary.com


Try pgDash Today!


Signup

14-day free trial — no credit card required