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 Opportunities
- How to Test Missing Index Opportunities
- Track Index Opportunities with Alerts
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 →