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 NUNITS', 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 Omni 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 Omni 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 Omni uses the
current database size as the upper limit on the total size of
recommended indexes.
The maximum time, in seconds, that the index advisor spends
running an analysis of its tracked queries.
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.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 Omni recommends indexes based
on all captured statements, instead of on a limited number of
statements.
[[["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 2026-10-26 UTC."],[],[]]
