NEW: Paste your query and schema data and we give you the best index. Launch pganalyze Index Advisor

Postgres Performance Optimization

pganalyze scales with your organization and is developed with your security in mind.

Comparison Over Time & Analyze Trends

Often times a performance issue you are investigating has occurred in the past, instead of happening at this very moment.

pganalyze allows easy access to historic data, and enables you to zoom into specific moments of your database server performance.

Config Tuning Recommendations

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

pganalyze also detects per-table configuration, for example for table-specific autovacuum settings.

Learn How Atlassian uses pganalyze Enterprise Edition

Smart Index Check

pganalyze highlights why a problematic query is slow and whether an index is potentially missing.

Once the index has been created, you can compare query performance and see the query speed improvements.

Buffer Cache Hit Ratio

The buffer cache is a central component of Postgres, and amongst other things is responsible for providing previously loaded data without having to go to disk.

In pganalyze you can easily see buffer cache hit ratio for each query, over time.