turbot/gcp_compliance

Control: Ensure 'log_statement_stats' database flag for Cloud SQL PostgreSQL instance is set to 'off'

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).

Usage

Run the control in your terminal:

powerpipe control run gcp_compliance.control.sql_instance_postgresql_log_statement_stats_database_flag_off

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run gcp_compliance.control.sql_instance_postgresql_log_statement_stats_database_flag_off --share

SQL

This control uses a named query:

sql_instance_postgresql_log_statement_stats_database_flag_off

Tags