System Catalogs / Statistics views
pg_stat_lock
Read the PG 20 devel manualThe pg_stat_lock view will contain one row for each lock type, showing cluster-wide locks statistics.
Reading PG 20devel·documented in 2 of 24 versions, 19 to 20
Development snapshot. These definitions may change before release.
- Kind
- Statistics views
- Columns in this snapshot
- 5
- Definition source
- English manual
Columns 5
As listed in the PostgreSQL 20 devel manual.
| Column | Type | Description / reference |
|---|---|---|
locktype | text | Type of the lockable object. See pg_locks for details. |
waits | bigint | Number of times a lock of this type had to wait because of a conflicting lock. Only incremented when the lock was successfully acquired after waiting longer than deadlock_timeout. |
wait_time | double precision | Total time spent waiting for locks of this type, in milliseconds. Only incremented when the lock was successfully acquired after waiting longer than deadlock_timeout. |
fastpath_exceeded | bigint | Number of times a lock of this type could not be acquired via fast path because the fast path slot limit was exceeded. Increasing max_locks_per_transaction can reduce this number. See Section 13.3.1.1 for which locks are eligible for fast-path locking; for ineligible lock types this counter is always zero. |
stats_reset | timestamp with time zone | Time at which these statistics were last reset. |
Column history across versions
Definition snapshot: english-manuals:c757681c5bf19c3d12f7c5238eb… · English manual source