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

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

postgres_locks_ALL • PostgreSQL

Graph Information

Field Internal name Type Warn Crit Info
RowShareLock rowsharelock gauge     Used by SELECT FOR SHARE and SELECT FOR UPDATE queries
RowExclusiveLock rowexclusivelock gauge     Used by UPDATE, DELETE and INSERT 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
ShareUpdateExclusiveLock shareupdateexclusivelock gauge     Used by VACUUM, ANALYZE and CREATE INDEX CONCURRENTLY queries
AccessShareLock accesssharelock gauge     Used by read only queries
ExclusiveLock exclusivelock gauge     Infrequently issued on system tables, or by applications

Column 1

Column 2