We just released a new major feature on pganalyze: Automated EXPLAIN plan analysis and plan visualization.Learn more

Deep insights into Postgres

Other monitoring tools show you what happened. pganalyze tells you why.

Automatic Insights into Postgres Query Plans

Learn more about Automatic Collection and Insights into Postgres Query Plans →

Visualization of query plans

pganalyze visualizes EXPLAIN output in a convenient tree view as opposed to the dreaded wall of text.

Plan insights

Get plan insights based on query plan information, as well as other information gathered from your database.

Referencing of schema data

Access relevant schema data for a table that a Sequential Scan node has scanned and review which indices exist on the table.

Plan grouping

pganalyze automatically groups similar query plans together and highlights plans that differ significantly.

Best-in-class Postgres Query Analysis

Learn more about Postgres Query Analysis with pganalyze →

Per-query statistics

Access statistics on a per-query basis and catch slow queries before they become big problems.

Automatically collect query plans

See how a query plan is executed with automatically collected execution plans using auto_explain.

Optimize your queries

Understand why a query is slow and whether an index can be created to make the query faster.

Deep query insights

Extract query samples from your log files and see how they relate to your query statistics.

Database Visualization and Sophisticated Dashboards

Learn more about Postgres Monitoring with pganalyze →

Avoid CLI tools

Uncover root causes to issues in minutes and stop wasting time with command line tools.

One single platform

View your logs and query statistics in one single platform and monitor your key metrics in real-time.

Trend analysis

Analyze meaningful trends and get insights into your query performance history.

Tuning recommendations

Collect detailed insights and receive tuning recommendations for your per-table autovacuum configuration.

Clear Understanding of Logs with pganalyze Log Insights

Learn more about pganalyze Log Insights →

Structured data

Log Insights automatically extracts the logs into structured data, and filters any sensitive information.

auto_explain integration

Automatically extract the output for the auto_explain extension that comes bundled with Postgres.

Postgres vacuum monitoring

Automatically combine information about vacuum logs with statistics data, and see it in one unified interface.

Careful PII filtering

Thanks to over 100 log filters, pganalyze filters PII from the log messages before it gets stored.

Performance Optimization for your Postgres Databases

Learn more about Postgres Performance Optimization with pganalyze →

Comparison over time

Get easy access to historic data, and zoom into specific moments of your database server performance.

Tuning recommendations

Set up automated checks that analyze your Postgres configuration and suggest optimizations.

Index checking

pganalyze highlights why a slow query is slow and points out if an index might be missing.

Buffer cache hit ratio

Easily get insights into your buffer cache hit ratio for each query, over time.

Secure Postgres Monitoring

Learn more about secure Database Monitoring with pganalyze →

Running on-premise

pganalyze can be run on-premise inside a Docker container behind your firewall, on your own servers.

Comply with local policies

Retain your database statistics data in the correct region of the world to comply with local policies.

Sensitive data

pganalyze normalizes query information so that only structural data is stored and presented.

SSO integration

pganalyze integrates with your Active Directory, LDAP or Google Apps setup. Okta coming soon.