0300-pg_io.yml

#==============================================================#
# 0300 pg_io
#==============================================================#
pg_io_18:
  name: pg_io
  desc: PostgreSQL I/O stats since v18
  query: |-
    SELECT backend_type AS "type",object,context,reads,read_bytes,read_time,writes,write_bytes,write_time,writebacks,writeback_time,
    extends,extend_bytes,extend_time,hits,evictions,reuses,fsyncs,fsync_time,extract(EPOCH FROM stats_reset) AS reset_time FROM pg_stat_io;

  ttl: 10
  timeout: 1
  min_version: 180000
  tags: [ cluster ]
  metrics:
    - type:               { usage: LABEL                              ,description: "Type of backend" }
    - object:             { usage: LABEL                              ,description: "Target object of an I/O operation, relation or temp" }
    - context:            { usage: LABEL                              ,description: "The context of an I/O operation. normal,vacuum,bulkread,bulkwrite" }
    - reads:              { usage: COUNTER ,default: 0                ,description: "Number of read operations, each of the size specified in op_bytes." }
    - read_bytes:         { usage: COUNTER ,default: 0                ,description: "Number of read bytes" }
    - read_time:          { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in read operations in seconds" }
    - writes:             { usage: COUNTER ,default: 0                ,description: "Number of write operations, each of the size specified in op_bytes." }
    - write_time:         { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in write operations in seconds" }
    - write_bytes:        { usage: COUNTER ,default: 0                ,description: "Number of write bytes" }
    - writebacks:         { usage: COUNTER ,default: 0                ,description: "Number of units of size op_bytes which the process requested the kernel write out to permanent storage." }
    - writeback_time:     { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in writeback operations in seconds" }
    - extends:            { usage: COUNTER ,default: 0                ,description: "Number of relation extend operations, each of the size specified in op_bytes." }
    - extend_bytes:       { usage: COUNTER ,default: 0                ,description: "Number of extend bytes" }
    - extend_time:        { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in extend operations in seconds" }
    - hits:               { usage: COUNTER ,default: 0                ,description: "The number of times a desired block was found in a shared buffer." }
    - evictions:          { usage: COUNTER ,default: 0                ,description: "Number of times a block has been written out from a shared or local buffer" }
    - reuses:             { usage: COUNTER ,default: 0                ,description: "The number of times an existing buffer is reused" }
    - fsyncs:             { usage: COUNTER ,default: 0                ,description: "Number of fsync calls. These are only tracked in context normal" }
    - fsync_time:         { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in fsync operations in seconds" }
    - reset_time:         { usage: GAUGE                              ,description: "Timestamp at which these statistics were last reset" }

pg_io_16:
  name: pg_io
  desc: PostgreSQL I/O stats
  query: |-
    SELECT backend_type AS "type", object, context, reads, read_time,writes,write_time,writebacks,writeback_time,extends,
      extend_time,hits,evictions,reuses,fsyncs,fsync_time,extract(EPOCH FROM stats_reset) AS reset_time FROM pg_stat_io;

  ttl: 10
  timeout: 1
  min_version: 160000
  max_version: 180000
  tags: [ cluster ]
  metrics:
    - type:               { usage: LABEL                              ,description: "Type of backend" }
    - object:             { usage: LABEL                              ,description: "Target object of an I/O operation, relation or temp" }
    - context:            { usage: LABEL                              ,description: "The context of an I/O operation. normal,vacuum,bulkread,bulkwrite" }
    - reads:              { usage: COUNTER ,default: 0                ,description: "Number of read operations, each of the size specified in op_bytes." }
    - read_time:          { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in read operations in seconds" }
    - writes:             { usage: COUNTER ,default: 0                ,description: "Number of write operations, each of the size specified in op_bytes." }
    - write_time:         { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in write operations in seconds" }
    - writebacks:         { usage: COUNTER ,default: 0                ,description: "Number of units of size op_bytes which the process requested the kernel write out to permanent storage." }
    - writeback_time:     { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in writeback operations in seconds" }
    - extends:            { usage: COUNTER ,default: 0                ,description: "Number of relation extend operations, each of the size specified in op_bytes." }
    - extend_time:        { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in extend operations in seconds" }
    - hits:               { usage: COUNTER ,default: 0                ,description: "The number of times a desired block was found in a shared buffer." }
    - evictions:          { usage: COUNTER ,default: 0                ,description: "Number of times a block has been written out from a shared or local buffer" }
    - reuses:             { usage: COUNTER ,default: 0                ,description: "The number of times an existing buffer is reused" }
    - fsyncs:             { usage: COUNTER ,default: 0                ,description: "Number of fsync calls. These are only tracked in context normal" }
    - fsync_time:         { usage: COUNTER ,default: 0  ,scale: 1e-3  ,description: "Time spent in fsync operations in seconds" }
    - reset_time:         { usage: GAUGE                              ,description: "Timestamp at which these statistics were last reset" }