pgDash

pgDash is a diagnostic and monitoring solution specifically designed for PostgreSQL deployments. It is intended for use by small to large enterprises, including Database Administrators, DevOps Engineers, IT Operations Managers, Software Developers, and E-commerce companies. According to the vendor, pgDash provides valuable insights and actionable information to ensure the health and optimal performance of PostgreSQL databases.

Key Features

Queries: According to the vendor, pgDash offers extensive insights into SQL queries, including time series graphs, execution plans visualization, and performance improvement suggestions.

Diagnostics: The vendor claims that pgDash automatically generates diagnostic reports that highlight issues which may impact the health and performance of PostgreSQL servers and databases.

Replication: According to the vendor, pgDash allows users to monitor replication metrics such as lags, replication slot information, and standby recovery progress to ensure data consistency.

Tables & Indexes: The vendor states that pgDash provides detailed information about tables and indexes, including size, bloat, activity, cache efficiency, and more.

Locks & Backends: According to the vendor, pgDash enables users to identify queries waiting on locks, track long-running transactions, and monitor idling transactions.

Inspector: The vendor claims that pgDash offers dashboards for key subsystem health and performance indicators across an entire fleet of Postgres servers and databases.

Teams: According to the vendor, pgDash allows users to share database access with team members while restricting their ability to delete server data.

Integrations: The vendor states that pgDash supports integrations with other systems such as AWS CloudWatch, PgBouncer, and Pgpool, providing a comprehensive view of the PostgreSQL system.

Alerting: According to the vendor, pgDash allows users to set meaningful alerts based on various metrics and receive notifications via email, Slack, PagerDuty, and more.

Configuration tuning: The vendor claims that pgDash provides recommendations on server configuration related to security, performance, and reliability.