Toggle navigation
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 can change this setting.

Recommendations

Useful for performance analysis.

Comments