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

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

postgres_locks_ALL • PostgreSQL

Graph Information

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

Column 1

Column 2