Join more than 25k Postgres enthusiasts and sign up for our newsletter!

Index Advisor (in-app in pganalyze)

The pganalyze Index Advisor is a tool to analyze your queries, determine how Postgres will scan the tables involved, and suggest indexes to make those scans more efficient.

This section describes the in-app Index Advisor. Looking for the standalone Index Advisor documentation? Continue here.

To understand better how recommendations are made, view the documentation for the pganalyze Indexing Engine, which runs behind the scenes and provides the data for the Index Advisor.


Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →