Overview munin-monitoring.org www.munin-monitoring.org
postgres locks trac munin

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

postgres_locks_trac_munin • PostgreSQL

Graph Information

Field Internal name Type Warn Crit Info
ShareRowExclusiveLock sharerowexclusivelock gauge     Only issued explicitly from 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
ExclusiveLock exclusivelock gauge     Infrequently issued on system tables, or by applications
RowExclusiveLock rowexclusivelock gauge     Used by UPDATE, DELETE and INSERT queries
AccessExclusiveLock accessexclusivelock gauge     Used by ALTER TABLE, DROP TABLE, TRUNCATE, REINDEX, CLUSTER and VACUUM FULL queries
RowShareLock rowsharelock gauge     Used by SELECT FOR SHARE and SELECT FOR UPDATE queries

Column 1

Column 2