Overview adm.grifon.fr db02.adm.grifon.fr
postgres locks monitoring

Graphs in same category
postgres xlog postgres users postgres tuples netbox postgres tuples monitoring postgres tuples master3 postgres tuples master2 postgres tuples master1 postgres tuples mantis postgres tuples mailmanweb postgres tuples mailmancore postgres tuples dev adherents postgres tuples adherents postgres transactions monitoring postgres transactions master3 postgres transactions master2 postgres transactions master1 postgres transactions mantis postgres transactions mailmanweb postgres transactions mailmancore postgres transactions dev adherents postgres transactions adherents postgres transactions ALL postgres size monitoring postgres size master3 postgres size master2 postgres size master1 postgres size mantis postgres size mailmanweb postgres size mailmancore postgres size dev adherents postgres size adherents postgres size ALL postgres scans netbox postgres scans monitoring postgres scans master3 postgres scans master2 postgres scans master1 postgres scans mantis postgres scans mailmanweb postgres scans mailmancore postgres scans dev adherents postgres scans adherents postgres querylength monitoring postgres querylength master3 postgres querylength master2 postgres querylength master1 postgres querylength mantis postgres querylength mailmanweb postgres querylength mailmancore postgres querylength dev adherents postgres querylength adherents postgres querylength ALL postgres locks monitoring postgres locks master3 postgres locks master2 postgres locks master1 postgres locks mantis postgres locks mailmanweb postgres locks mailmancore postgres locks dev adherents postgres locks adherents postgres locks ALL postgres connections monitoring postgres connections master3 postgres connections master2 postgres connections master1 postgres connections mantis postgres connections mailmanweb postgres connections mailmancore postgres connections dev adherents postgres connections db postgres connections adherents postgres connections ALL postgres checkpoints postgres cache monitoring postgres cache master3 postgres cache master2 postgres cache master1 postgres cache mantis postgres cache mailmanweb postgres cache mailmancore postgres cache dev adherents postgres cache adherents postgres cache ALL postgres bgwriter postgres autovacuum
daily graph
weekly graph
monthly graph
yearly graph

Graph Information

PostgreSQL locks

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

Column 1

Column 2