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