pganalyze provides deep insights into Postgres. Other monitoring tools show you what happened. pganalyze tells you why. We've just introduced automated EXPLAIN plan collection, visualization and insights, so you know exactly why queries are slow.
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.
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! :)
pganalyze