Subscribe
Sign in
Start new thread
pganalyze
p/pganalyze
Automated EXPLAIN Plan Visualization & Insights for Postgres
Visit Product
Lukas Fittl
pganalyze Index Advisor for Postgres — A better way to index your Postgres database
Featured
1
•
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.
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! :)