What is pgDash?
pgDash is a comprehensive diagnostic and monitoring solution designed to help ensure the ongoing health and performance of PostgreSQL deployments. It provides core reporting and visualization functionality, including collecting and displaying PostgreSQL information, diagnostics, time-series graphs, detailed reports, alerting, and team collaboration features. The tool works with AWS RDS and Aurora, offering both SaaS and self-hosted/on-premise deployment options.
pgDash collects hundreds of pieces of information and metrics about PostgreSQL servers, integrating them into a comprehensive monitoring model. It includes features like query analysis with execution plans, diagnostics for potential issues, replication monitoring, tables and indexes insights, lock and backend tracking, and an inspector for key subsystem health. The AI-enhanced chat feature allows users to ask questions in natural language about server status, configuration, and performance, providing real-time answers and insights.
Features
- Queries: Extensive information about each SQL query executed, including time series graphs, execution plans with visualization, and suggestions to improve query performance
- Diagnostics: Examines PostgreSQL server and databases scanning for potential issues that can impact health and performance
- Replication: Monitor extensive replication metrics, including lags at primary and standby servers, physical and logical replication slot information, and standby recovery progress
- Tables & Indexes: Shows information about each table and index, like size, bloat, activity, vacuum and analyze information, and cache efficiency
- AI-enhanced Chat: Provides information and insights about PostgreSQL server through natural language queries, answering questions about status, configuration, and performance in real-time
Use Cases
- Monitoring PostgreSQL server health and performance
- Diagnosing and resolving database performance issues
- Tracking replication metrics and ensuring data consistency
- Analyzing query execution plans for optimization
- Managing team access to PostgreSQL monitoring data
FAQs
-
What is counted as a server for billing purposes?
For billing purposes, a 'server' is technically a PostgreSQL cluster—a single postgres server process managing a set of databases. For AWS RDS, it is a single RDS primary instance or a single RDS read replica instance. For AWS Aurora, it is a single Aurora Replica within an Aurora DB Cluster. -
How does pgDash handle adding or deleting database servers?
You can add and delete database servers anytime. To ensure a server is no longer included in your billing count, you need to delete it from pgDash entirely. -
What payment methods are accepted for pgDash?
For monthly payments, all major credit cards are accepted, including Visa, Mastercard, American Express, and Discover. For annual payments, wire transfers and ACH (US only) are accepted in addition to credit cards. -
How much does the self-hosted version of pgDash cost?
The self-hosted version is available for Pro and Enterprise plans, priced similarly to the SaaS version but licensed annually with a 10% discount off list prices. Subscription fees are payable annually in advance.
