Index advisor flags

This page describes the database flags that AlloyDB for PostgreSQL uses to enable and manage features specific to its index advisor extension.

Database flags

google_db_advisor.auto_advisor_max_time_in_seconds	Type Integer Default 1800 Restart required No The maximum time, in seconds per day, that the index advisor spends running automated analyses of its tracked queries.
google_db_advisor.auto_advisor_schedule	Type String Default 'EVERY 24 HOURS' Restart required No Defines the frequency of the index advisor's automated analysis. The value is a single-quoted string of the format 'EVERY N UNITS', where N is an integer, and UNITS is either HOURS or DAYS.
google_db_advisor.enable_auto_advisor	Type Boolean Default on Restart required No If on, then AlloyDB runs the index advisor's analysis on an automated schedule, with a frequency set by the separate google_db_advisor.auto_advisor_schedule flag.
google_db_advisor.enabled	Type Boolean Default on Restart required Yes Controls whether the AlloyDB index advisor is enabled.
google_db_advisor.max_index_width	Type Integer Default 2 Restart required No The maximum number of columns that a recommended index can contain.
google_db_advisor.max_num_indexable_columns	Type Integer Default 1000 Restart required No The maximum number of indexable columns that index advisor tracks.
google_db_advisor.max_statement_length	Type Integer Default 102400 Restart required No The maximum length, in bytes, of queries that the index advisor tracks.
google_db_advisor.max_storage_size_in_mb	Type Integer Default 0 Restart required No The maximum total size, in megabytes, of the indexes that the index advisor recommends. If set to 0, then AlloyDB uses the current database size as the upper limit on the total size of recommended indexes.
google_db_advisor.recommend_indexes_on_partitions	Type Boolean Default off Restart required No Controls whether to enable recommending indexes on individual table partitions.
google_db_advisor.recommendation_max_time_in_seconds	Type Integer Default 600 Restart required No The maximum time, in seconds, that the index advisor spends running an analysis of its tracked queries.
google_db_advisor.top_k_slowest_statements	Type Integer Default 100 Restart required No The index advisor bases its recommendations on the slowest-executing statements out of all the queries it tracks. The value set by this flag defines the size of this set. If set to 2147483647 (the maximum allowed value), then AlloyDB recommends indexes based on all captured statements, instead of on a limited number of statements.