Index advisor flags

The maximum time, in seconds per day, that the index advisor spends running automated analyses of its tracked queries.

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.

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.

Recommends ScaNN vector indexes depending on the workload. Requires the google_ml_integration extension to be enabled.

Controls whether the AlloyDB index advisor is enabled.

The maximum number of columns that a recommended index can contain.

The maximum number of indexable columns that index advisor tracks.

The maximum length, in bytes, of queries that the index advisor tracks.

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.

Controls whether to enable recommending indexes on individual table partitions.

The maximum time, in seconds, that the index advisor spends running an analysis of its tracked queries.

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.