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.

• Getting Started with pganalyze Index Advisor
• How to Reason About Missing Index Insights
• Experimenting with Different Configurations
• How to Test Missing Index Insights
• Track Index Insights with Alerts
• Index Consolidation Insights (early access)

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.