log_lock_failures

Controls whether a detailed log message is produced when a lock acquisition fails. This is useful for analyzing the causes of lock failures. Currently, only lock failures due to SELECT NOWAIT is supported. The default is off. Only superusers and users with the appropriate SET privilege can change this setting.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

18 19 20

boot val: off
category: Reporting and Logging / What to Log
context: superuser
doc same as: Unknown
documented: true
enumvals: Unknown
extra desc: Unknown
lang: en
max val: Unknown
metadata version: 18
min val: Unknown
name: log_lock_failures
short desc: Logs lock failures.
source: pg-settings-source-snapshot
unit: Unknown
vartype: bool

Definition PG 18

Controls whether a detailed log message is produced when a lock acquisition fails. This is useful for analyzing the causes of lock failures. Currently, only lock failures due to SELECT NOWAIT is supported. The default is off. Only superusers and users with the appropriate SET privilege can change this setting.

Compare versions

Complete source facts

doc html

<p>
        Controls whether a detailed log message is produced
        when a lock acquisition fails.  This is useful for analyzing
        the causes of lock failures.  Currently, only lock failures
        due to <code class="literal">SELECT NOWAIT</code> is supported.
        The default is <code class="literal">off</code>.  Only superusers and
        users with the appropriate <code class="literal">SET</code> privilege
        can change this setting.
       </p>

documentation revision

{"inputs":[{"file":"runtime-config-logging.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"278d913b9c0f735c5cd7b35fd7205826bbd9c449805370d2dbe54105c0ed1d88","version":"18.7"},{"file":"runtime-config-logging.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"68c010254e1859ec0b76f06a563babd51a6c38997f1242e35e4c6b649724b1cb","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:66b1d95e9c8082d22788532df81bffa89cd2bc5745c073acee9550c4288849f2

Text language: en · wiki-repair-20261023:66b1d95e9c8082d22788532df81bffa89cd2bc5745c073acee9550c4288849f2