Description:
The 'log_statement_stats' flag controls the inclusion of end to end performance statistics of a SQL query in the PostgreSQL logs for each query. This cannot be enabled with other module statistics ('log_parser_stats', 'log_planner_stats', 'log_executor_stats').
Rationale:
The 'log_statement_stats' flag enables a crude profiling method for logging end to end performance statistics of a SQL query. This can be useful for troubleshooting but may increase the amount of logs significantly and have performance overhead. This recommendation is applicable to PostgreSQL database instances.
Using Console:
Using Command Line:
gcloud sql instances list
gcloud sql instances patch INSTANCE_NAME --database-flags log_statement_stats=off
Note: This command will overwrite all database flags previously set. To keep those and add new ones, include the values for all flags you want set on the instance; any flag not specifically included is set to its default value. For flags that do not take a value, specify the flag name followed by an equals sign ("=").
.