pgDash is a comprehensive diagnostic and monitoring solution designed to help you ensure the ongoing health and performance of your PostgreSQL deployment.
“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
Extensive information about each SQL query executed, including time series graphs, execution plans with visualization, and suggestions to improve query performance.
Diagnostics examines your PostgreSQL server and databases scanning for potential issues that can impact the health and performance of the deployment.
pgDash shows you information about each table and index, like size, bloat, activity, vacuum and analyze information, cache efficiency and more.
See which queries and waiting for which others. Track backends waiting on locks, transactions that have been open too long, idling transactions.
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.
pgDash can collect metrics from other systems associated with your PostgreSQL server to provide a comprehensive picture of the entire system status. pgDash currently supports two integrations: AWS CloudWatch and PgBouncer. pgDash in conjunction with pgmetrics can collect metrics and information about your AWS RDS instances and Aurora Replicas via the AWS CloudWatch and CloudWatch Logs APIs. With the PgBouncer integration, you can monitor your PgBouncer's pooling efficiency, load and client wait time to ensure that PgBouncer does not have a negative impact on application query latency.
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, PagerDuty, VictorOps, xMatters and Webhooks. 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.
pgDash collects hundreds of pieces of information and metrics about your Postgres server and brings it together into a comprehensive monitoring model. More than dashboards and alerts, it lets you reason out issues like why the WAL files keep increasing or which indices have not been used in the last month all from a single UI.
“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