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.