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 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.
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.
[[["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-07-09 UTC."],[[["This page details the database flags used by AlloyDB for PostgreSQL to manage its index advisor extension."],["The `google_db_advisor.enabled` flag controls whether the index advisor is active, and this requires a restart to take effect."],["The `google_db_advisor.auto_advisor_schedule` and `google_db_advisor.enable_auto_advisor` flags are used to determine the frequency and enable automatic analysis."],["Flags such as `google_db_advisor.max_index_width`, `google_db_advisor.max_storage_size_in_mb` and others, allow customization of the index advisor's behavior, such as limiting index characteristics, storage used and tracked statement length."],["The `google_db_advisor.top_k_slowest_statements` flag allows to determine how many of the slowest statements are used for the index recommendations, while setting it to `2147483647` will use all tracked statements."]]],[]]
