Index advisor overview

This page describes the AlloyDB for PostgreSQL index advisor.

AlloyDB offers a fully managed index advisor that tracks the queries your database regularly handles. Periodically, the index advisor analyzes these queries to recommend new indexes that can improve query performance. Enabling the index advisor lets you detect potential performance issues with queries and get recommendations for index optimization.

How does the index advisor work?

The AlloyDB index advisor helps you improve query processing by doing the following:

  • Helping you identify a set of indexes.
  • Providing details to help you create recommended indexes, for example, estimated storage size and impact of indexes on a query.

You can also use the index advisor with Query Insights. The index advisor stores and displays the CREATE INDEX command that contains the database name, schema name, table name, and column names. The tracked queries are all normalized queries with all literals removed.

Index recommendations are encrypted at rest.

For more information about how to use the index advisor, see Use index advisor. For more information how to use it with query insights, see Use index advisor with query insights.