A configuration parameter determining how long to wait before checking for a deadlock condition.

deadlock_timeout is a configuration parameter determining the amount of time to wait on a lock before checking to see if there is a deadlock condition.

deadlock_timeout was added in PostgreSQL 6.4.

Default value

The default value for deadlock_timeout is: 1s.


If log_lock_waits is set to on, deadlock_timeout also determines the interval before the lock wait is logged.

Change history


GUC configuration item, Locking

See also

log_lock_waits, statement timeout