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