postgres_locks_ALL •
PostgreSQL
Graph Information
Field | Internal name | Type | Warn | Crit | Info |
---|---|---|---|---|---|
ShareRowExclusiveLock | sharerowexclusivelock | gauge | Only issued explicitly from applications | ||
ShareUpdateExclusiveLock | shareupdateexclusivelock | gauge | Used by VACUUM, ANALYZE and CREATE INDEX CONCURRENTLY queries | ||
RowShareLock | rowsharelock | gauge | Used by SELECT FOR SHARE and SELECT FOR UPDATE queries | ||
AccessExclusiveLock | accessexclusivelock | gauge | Used by ALTER TABLE, DROP TABLE, TRUNCATE, REINDEX, CLUSTER and VACUUM FULL queries | ||
RowExclusiveLock | rowexclusivelock | gauge | Used by UPDATE, DELETE and INSERT queries | ||
ExclusiveLock | exclusivelock | gauge | Infrequently issued on system tables, or by applications | ||
ShareLock | sharelock | gauge | Used by CREATE INDEX queries | ||
AccessShareLock | accesssharelock | gauge | Used by read only queries |