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.