Subscribe
Sign in
pganalyze
p/pganalyzeAutomated EXPLAIN Plan Visualization & Insights for Postgres
Start new thread
Lukas Fittl

pganalyze Index Advisor for Postgres - A better way to index your Postgres database

by
The index advisor makes recommendations for creating the best indexes for your Postgres queries, based on the schema and table statistics information. Improve query performance and save developer time by quickly getting the right CREATE INDEX command.

Add a comment

Replies

Best
Lukas Fittl
Maker
We're launching the new pganalyze Index Advisor today (https://pganalyze.com/blog/intro...) - this is both a free standalone tool, as well as an automatic experience for pganalyze customers. Based on the Postgres queries, as well as the schema and table sizes, we calculate which indexes work best for the query. We've built the index advisor using the Postgres planner itself, which knows best which indexes need to be created. In the browser we run using the planner code compiled to WebAssembly, with all data staying local within your browser. Feedback & thoughts welcome! :)