| 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 |
