Query: Ensure 'log_planner_stats' database flag for Cloud SQL PostgreSQL instance is set to 'off'

Description

The same SQL query can be executed in multiple ways and still produce different results. The PostgreSQL planner/optimizer is responsible to create an optimal execution plan for each query. The log_planner_stats flag controls the inclusion of PostgreSQL planner performance statistics in the PostgreSQL logs for each query.

Query

Tables used in this query:

• gcp_sql_database_instance

Controls using this query:

• 6.2.10 Ensure 'log_planner_stats' database flag for Cloud SQL PostgreSQL instance is set to 'off'
• Ensure 'log_planner_stats' database flag for Cloud SQL PostgreSQL instance is set to 'off'

SQL