AI TOOL PROFILE
pgDash: PostgreSQL Monitoring and Diagnostics
- Software Development
- Database Performance
- 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.
At a glance
- Best for
- Software companies, PostgreSQL database administrators, Teams using AWS RDS or Aurora, Businesses requiring on-premise monitoring
- Key use cases
- Query Performance Analysis, Replication Health Tracking, Capacity Planning, Database Health Auditing
- Integrations
- AWS CloudWatch, PgBouncer, Pgpool, Slack, PagerDuty
- Official website
- Visit pgdash official website
How AI is used
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
Query Analysis
Provides execution plan visualization and time-series graphs for SQL queries.
Replication Monitoring
Tracks replication lags at primary and standby servers, and standby recovery progress.
Database Diagnostics
Automatically generates reports to highlight potential issues that may impact server health.
Index and Table Tracking
Monitors table and index size, bloat, and identifies indexes that have not been used recently.
Lock and Backend Monitoring
Tracks backends waiting on locks and identifies transactions that have been open too long.
AI-enhanced Chat
Available in Pro and Enterprise tiers to provide information about server status and performance.
Change Alerts
Notifies users of database changes such as the addition or deletion of users, tables, or indexes.
Use Cases
Query Performance Analysis
Analyzing execution plans and visualization to identify slow SQL queries.
Replication Health Tracking
Monitoring physical and logical replication slots and standby recovery progress.
Capacity Planning
Tracking table size and growth to manage disk usage and tablespace allocation.
Database Health Auditing
Using automated diagnostic reports to scan for configuration issues.
Integrations
- AWS CloudWatch
- PgBouncer
- Pgpool
- Slack
- PagerDuty
- VictorOps
- xMatters
FAQ
Does pgDash access the actual data inside my tables?
- No, pgDash uses pgmetrics to collect only metadata, statistics, and structural information; it does not collect the values stored within the tables.
Is there a self-hosted version of pgDash?
- Yes, a self-hosted on-premise version is available for Pro and Enterprise customers, which can be run in air-gapped environments.
What are the pricing options for pgDash?
- The Basic plan starts at $100/month for up to 5 servers, and the Enterprise plan is $200/month for 20+ servers.
Does pgDash work with AWS managed databases?
- Yes, pgDash supports AWS RDS PostgreSQL and AWS Aurora.
Source category: Software Development
Source subcategory: Database Performance
More tools in Software Development
Other published listings in the Software Development category.
More tools in the Database Performance software type
Related listings that share the same software type for comparison and shortlisting.
