0750-pg_defpart.yml

#==============================================================#
# 0750 pg_defpart
#==============================================================#
pg_defpart:
  name: pg_defpart
  desc: PostgreSQL default partition tuples
  query: SELECT CURRENT_CATALOG AS datname, relnamespace::RegNamespace || '.' || relname AS relname, reltuples AS tuples FROM pg_class WHERE relpartbound IS NOT NULL AND pg_catalog.pg_get_expr(relpartbound, oid) = 'DEFAULT' ORDER BY reltuples DESC LIMIT 64;
  ttl: 60
  timeout: 1
  min_version: 110000
  metrics:
    - datname:             { usage: LABEL    ,description: "Database name of this default partition" }
    - relname:             { usage: LABEL    ,description: "Schema qualified default partition relation name" }
    - tuples:              { usage: GAUGE    ,description: "Number of tuples in this default partition" }