GCP-SQL-PostgreSQL-Log-Lock-Waits-Flag-Enabled

Owned by naveen
Dec 08, 2021
1 min read

Severity : Low

Description : SQL instance for PostgreSQL database provides log_lock_waits flag. It is not enabled by default. Enabling it will make sure that log messages are generated whenever a session waits longer than deadlock_timeout to acquire a lock.

Remediation Steps : Ensure that log_lock_waits flag is enabled for all PostgreSQL instances.

Blue Hexagon Proprietary