Maximize PostgreSQL Performance

pgDash provides a range of innovative features to help you maximise the performance of your PostgreSQL deployment.

Diagnostics

Diagnostics

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.

Locks & Backends

Locks

See which queries are waiting for which others. Track backends waiting on locks, transactions that have been open too long and idling transactions.

Queries

Queries

Interactively filter and browse slow SQL query information from pg_stat_statements. Isolate and view queries that were run during a specified time range.

Top k

Top k

Identify the top tables, indexes or schemas, based on a number of criteria, like size, rows, growth, object counts and more.


Keep an Eye on Core PostgreSQL Functions

pgDash provides insight into core PostgreSQL functions so that you can monitor activity and take corrective action before issues become critical.

Tables & Indexes

Tables and Indexes

Review information about each table and index, like size, bloat, activity, vacuum and analyze information, cache efficiency and more.

Databases

Databases

View and monitor database-level metrics like commit ratio, cache efficiency, frozen xid age and more. Identify extensions that need to be upgraded.

System Information

System Information

Collect and monitor important system information including load average, memory usage and swap usage as well as tablespace-wise disk usage.

Backends

Backends

Track backends waiting on locks, transactions that have been open too long, idling transactions. Filter, sort and view all running backends.

Tablespaces

Tablespaces

Monitor and track disk usage at tablespace level. Set threshold alerts for high disk usage.

Replication

Replication

Monitor extensive replication metrics, including lags at primary and standby servers, physical and logical replication slot information, and standby recovery progress.


Make Sure Everyone is in the Loop

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.

Alerts

pgDash Tables and Indexes

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 or PagerDuty.

Change Alerts

pgDash Backends

Get Change Alerts automatically and stay on top of important changes to your PostgreSQL databases, like addition or deletion of users, tables, indexes, or abrupt increases or decreases in table size, and more.

Team Sharing

pgDash Tables and Indexes

Share access to particular databases with Team members who need to stay in the loop. The team members you're sharing with can view all information, metrics and graphs about the shared database, but will not be able to delete any server data.


Try pgDash Today!


Signup

14-day free trial — no credit card required