| 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.
On StackOverflow
On pgsql-hackers
- Re: Adding wait events statistics
- A thousand pg_commit_ts truncate attempts per second, two restarting autovacuum processes, and a explosive replication lag. Oh my.
- Re: Add “FOR UPDATE NOWAIT” lock details to the log.
- Re: Patch: Show queries of processes holding a lock
- Patch: Show queries of processes holding a lock