pgDash provides a range of innovative diagnostic and monitoring features to help you gain insight and maximise the performance of your PostgreSQL deployment.
Review automatically generated Diagnostic reports that examine your PostgreSQL servers and databases and highlight issues that can impact the health and performance of your deployment.
Filter and browse slow SQL query information from pg_stat_statements. View queries that were run during a specified time range. Review query execution plans.
Find indexes that haven't been used recently, that are candidates for dropping. Identify indexes that are too bloated and need reindexing.
pgDash provides insight into core PostgreSQL functions so that you can monitor activity and take corrective action before issues become critical.
Review information about each table and index, like size, bloat, activity, vacuum and analyze information, cache efficiency and more.
Collect and monitor important system information including load average, memory usage and swap usage as well as tablespace-wise disk usage.
From alerting to team sharing, pgDash provides features to assist in making sure that you and your team are on top of crucial information about your PostgreSQL deployment.
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 and more.