0530-pg_clustering.yml

#==============================================================#
# 0530 pg_clustering
#==============================================================#
pg_clustering:
  name: pg_clustering
  desc: PostgreSQL cluster or vacuum full progress (v12+)
  query: SELECT datname, pid, relid::RegClass AS relname, heap_tuples_scanned AS tup_scan, CASE WHEN heap_blks_total > 0 THEN 1.0 * heap_blks_scanned / heap_blks_total ELSE 0 END AS progress FROM pg_stat_progress_cluster;
  ttl: 10
  min_version: 120000
  tags: [ cluster, primary ]
  metrics:
    - datname:     { usage: LABEL ,description: "Name of database been clustering" }
    - pid:         { usage: LABEL ,description: "Process id of indexing table" }
    - relname:     { usage: LABEL ,description: "Relation name of indexed table" }
    - tup_scan:    { usage: GAUGE ,description: "How much tuple been scanned" }
    - progress:    { usage: GAUGE ,description: "Progress of heap been processed" }