Overview munin-monitoring.org demo.munin-monitoring.org
postgres locks munin

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

postgres_locks_munin • PostgreSQL

Graph Information

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

Column 1

Column 2