pganalyze Index Advisor for Postgres

Automatically validate that existing indexes are useful, get index recommendations to improve performance, and reduce load on your database.

Postgres Index Recommendations

The pganalyze Index Advisor that recommends indexes across queries for your whole database, built on the new pganalyze Indexing Engine.

We aim to provide a service that can do a lot of heavy-lifting for you when it comes to surfacing performance improvement opportunities.

Screenshot of pganalyze Index Advisor
Screenshot of pganalyze Index Advisor Index Recommendation

Improve Postgres Query Performance

Get index recommendations based on your database schema and statistics and your query workload and additional insights for each table scan, and look at the scan expressions and cost improvements.

Recommended indexes help improve performance and reduce load on your database.

Simple and Actionable: You are in Control

If you want to use the recommended index, simply copy the CREATE INDEX command right from the pganalyze Index Advisor! Should you already be using the best index, you can go on and rest assured that your performance is already optimized.

Screenshot of pganalyze Index Advisor CREATE Index copy button
Postgres Index Advisor

Standalone Postgres Index Advisor

Imagine the following scenarios: You encounter a slow query in your local development environment and want to verify whether it’s indexed correctly. Or, you have a fire burning on production, and one particular query shows up at the top.

Use our standalone Index Advisor tool! Simply paste your query and schema data and get insights on whether existing indexes are useful, or learn why indexes you thought might help are ignored.

The public Index Advisor assumes a default size of 10 GB for each table - but you can edit those sizes at any time to match real workloads.

Launch pganalyze Index Advisor for Postgres

Robin Fernandes
Our overall usage of Postgres is growing, as is the amount of data we're storing and the number of users that interact with our products. pganalyze is essential to making our Postgres databases run faster, and makes sure end-users have the best experience possible.
- Robin Fernandes, Software Development Manager, Atlassian

Hundreds Of Companies Monitor Their Production PostgreSQL Databases With pganalyze