Postgres Query Analysis & Postgres Explain Plans

Discover the root cause of critical issues, optimize slow queries, and find missing indexes.

Query drill-down analysis and per-query statistics

See detailed statistics on a per-query basis and know what to focus your efforts on.

Identify slowdowns for specific queries over time (e.g. due to a different query plan being chosen), I/O vs CPU time for each query, or buffer cache hit ratio for each query.

Screenshot of Query Details page
Screenshot of Query Performance Overview

Catch slow queries before they become big problems

Benefit from insights into your query performance history to detect slow queries.

pganalyze lets you sort all queries on your database by different characteristics, such as “% of all runtime”, “average runtime”, or “calls per minute”.

pganalyze Index Advisor

Easily avoid a common cause for slow query performance: A missing index.

pganalyze will highlight why a slow query is slow and whether an index can be created to make the query perform faster.

Screenshot of Index Advisor feature
Screenshot of EXPLAIN Plans feature

Postgres explain plans

Drastically improve your database performance with explain plans.

pganalyze automatically collects explain plans for slow queries from when the query was executed using auto_explain. This allows you to get insights on how PostgreSQL executes its query plan and identify performance bottlenecks.

Specific example queries for more insights

Understand which tenants in your system are producing slow queries.

Extract specific query samples from your log files and see them associated in one place together with your query statistics. This provides you with the insights you need to improve PostgreSQL query performance.

Screenshot of query normalization

Jon Erdman
The scale and volume of data we handle meant that, prior to using pganalyze, I had no easy visibility into this information. pganalyze has saved me at least a day of forensic analysis when debugging database problems.
- Jon Erdman, Senior Postgres DBA, Bitbucket Cloud

Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze

Atlassian
DoorDash
Moody's
fuboTv
Salsify
CounterPath
Ipsy