Overview server build-test
postgres locks ALL

Graphs in same category
postgres users postgres locks ALL postgres bgwriter postgres autovacuum postgres transactions ALL postgres size ALL postgres xlog postgres checkpoints postgres cache ALL postgres connections db postgres connections ALL postgres querylength ALL

postgres_locks_ALL • PostgreSQL
daily graph
weekly graph
monthly graph
yearly graph

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

Column 1

Column 2