Wiki / Statistics & Metrics

Amount of decoded transaction data spilled to disk while performing decoding of changes from WAL for this slot. This and other spill counters can be used to gauge the I/O which occurred during logical decoding and allow tuning logical_decoding_work_mem.

View

pg_stat_replication_slots

Field

spill_bytes

SQL type

bigint

Units named in the field definition

Not specified

Reset observation

Time at which these statistics were last reset

documented

true

field

spill_bytes

manual path

/docs/18/monitoring-stats.html

signature

SELECT spill_bytes FROM pg_catalog.pg_stat_replication_slots;

source only

false

sql type

bigint

units mentioned

Unknown

view

pg_stat_replication_slots