Type: bool
Default: off
Context: superuser
Restart: false

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 and users with the appropriate SET privilege can change this setting.

Recommendations

Useful for performance analysis.

Comments