PostgreSQL version:

log_lock_waits

Controls whether a log message is produced when a session waits longer than deadlock_timeout to acquire a lock. This is useful in determining if lock waits are causing poor performance. The default is off. Only superusers can change this setting.

Recommendations

Useful for performance analysis.

Comments