Google > SQL >

PostgreSQL Log Lock Waits Flag Enabled

MEDIUM
Source
CloudSploit
ID
postgresql-log-lock-waits-flag-enabled

PostgreSQL Log Lock Waits Flag Enabled

Ensures SQL instances for PostgreSQL type have log_lock_waits flag enabled.

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.

Ensure that log_lock_waits flag is enabled for all PostgreSQL instances.