pgDash: PostgreSQL Monitoring and Diagnostics
pgDash helps businesses monitor the health and performance of their PostgreSQL deployments. It is designed for teams that require query visualization and diagnostic reporting.
At a glance
- Category
- Software Development
- Best for
- Software companies, PostgreSQL database administrators, Teams using AWS RDS or Aurora, Businesses requiring on-premise monitoring
- Pricing
- Basic tier starts at $100 per month for up to 5 servers; Enterprise tier is $200 per month for 20+ servers. A 14-day free trial is available.
- Key use cases
- Query Performance Analysis, Replication Health Tracking, Capacity Planning, Database Health Auditing
- Integrations
- AWS CloudWatch, PgBouncer, Pgpool, Slack, PagerDuty
- Official website
- pgdash.io
pgDash is a diagnostic and monitoring tool for PostgreSQL environments. It collects server metadata and statistics using the open-source pgmetrics tool to provide a view of database health without accessing actual table data.
The software supports PostgreSQL clusters, including AWS RDS and Aurora. It provides metrics ranging from query execution plans to replication lag and index bloat.
Buyers can choose between a SaaS deployment or a self-hosted on-premise version, which may be run in air-gapped environments. The tool includes an AI-enhanced chat interface in higher tiers to help users query server status in natural language.
Buyers should confirm their server count and deployment requirements, as pricing is based on the number of monitored servers and certain features like team sharing and change alerts are available only in the Pro and Enterprise tiers.
Key Features
Provides execution plan visualization and time-series graphs for SQL queries.
Tracks replication lags at primary and standby servers, and standby recovery progress.
Automatically generates reports to highlight potential issues that may impact server health.
Monitors table and index size, bloat, and identifies indexes that have not been used recently.
Tracks backends waiting on locks and identifies transactions that have been open too long.
Available in Pro and Enterprise tiers to provide information about server status and performance.
Notifies users of database changes such as the addition or deletion of users, tables, or indexes.
Use Cases
Analyzing execution plans and visualization to identify slow SQL queries.
Monitoring physical and logical replication slots and standby recovery progress.
Tracking table size and growth to manage disk usage and tablespace allocation.
Using automated diagnostic reports to scan for configuration issues.
Best For
Integrations
Pricing
Basic tier starts at $100 per month for up to 5 servers; Enterprise tier is $200 per month for 20+ servers. A 14-day free trial is available.
FAQ
No, pgDash uses pgmetrics to collect only metadata, statistics, and structural information; it does not collect the values stored within the tables.
Yes, a self-hosted on-premise version is available for Pro and Enterprise customers, which can be run in air-gapped environments.
The Basic plan starts at $100/month for up to 5 servers, and the Enterprise plan is $200/month for 20+ servers.
Yes, pgDash supports AWS RDS PostgreSQL and AWS Aurora.
Source category: Software Development
Source subcategory: Database Performance
