0450-pg_lock.yml

#==============================================================#
# 0450 pg_lock
#==============================================================#
pg_lock:
  name: pg_lock
  desc: PostgreSQL lock distribution by mode and database
  query: |
    SELECT datname, mode, coalesce(count, 0) AS count
      FROM (SELECT d.oid AS database, d.datname, l.mode FROM pg_database d, unnest(ARRAY ['AccessShareLock','RowShareLock','RowExclusiveLock','ShareUpdateExclusiveLock', 'ShareLock','ShareRowExclusiveLock','ExclusiveLock','AccessExclusiveLock']) l(mode) WHERE d.datallowconn AND NOT d.datistemplate) base
      LEFT JOIN (SELECT database, mode, count(*) AS count FROM pg_locks WHERE database IS NOT NULL GROUP BY 1, 2) cnt USING (database, mode);
  ttl: 10
  min_version: 090400
  tags: [ cluster ]
  metrics:
    - datname: { usage: LABEL ,description: "Name of the database this backend is connected to" }
    - mode:    { usage: LABEL ,description: "Name of the lock mode held or desired by this process" }
    - count:   { usage: GAUGE ,description: "Number of locks of corresponding mode and database" }