Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-03-05 UTC."],[[["AlloyDB provides a managed index advisor that analyzes database queries to suggest new indexes for performance improvement."],["The index advisor helps users identify and create indexes, providing details like estimated storage size and impact on queries."],["The `CREATE INDEX` command, including database, schema, table, and column names, is displayed for recommended indexes."],["The index advisor is designed to work in conjunction with Query Insights, with all queries tracked after literals have been removed, and recommendations encrypted at rest."]]],[]]
