Query: Ensure that the 'log_lock_waits' database flag for Cloud SQL PostgreSQL instance is set to 'on'

Description

Enabling the log_lock_waits flag for a PostgreSQL instance creates a log for any session waits that take longer than the allotted deadlock_timeout time to acquire a lock.

Query

Tables used in this query:

• gcp_sql_database_instance

Controls using this query:

• 6.2.6 Ensure that the 'log_lock_waits' database flag for Cloud SQL PostgreSQL instance is set to 'on'
• Ensure that the 'log_lock_waits' database flag for Cloud SQL PostgreSQL instance is set to 'on'

SQL