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.

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.