Database advisor flags

You can use AlloyDB for PostgreSQL database flags to enable and manage features for the index advisor extension and the capability to tune SQL queries (in Preview).

Index advisor flags

The following table lists the database flags for the index advisor:

google_db_advisor.auto_advisor_max_time_in_seconds_per_day	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.enable_vector_index_advisor	Type Boolean Default on Restart required No Recommends ScaNN vector indexes depending on the workload. Requires that you enable the alloydb_scann extension.
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 the 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.

SQL tuning flags

Preview

This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of the Service Specific Terms. Pre-GA features are available "as is" and might have limited support. For more information, see the launch stage descriptions.

The following table lists the database flags for SQL query tuning:

google_db_advisor.enable_ai_tune_sql	Type Boolean Default off Restart required No If on, then AlloyDB enables the capability to tune SQL queries. You can request manual tuning recommendations by running the ai.tune_sql function.
google_db_advisor.llm_model_id	Type String Default 'non-existent-model' Restart required No Specifies the model ID of the registered LLM endpoint that AlloyDB uses to generate SQL query tuning recommendations with the ai.tune_sql function.