pg_stat_replication_slots.spill_bytes

Description

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

Usage

SELECT spill_bytes FROM pg_catalog.pg_stat_replication_slots;

View semantics

The pg_stat_replication_slots view will contain one row per logical replication slot, showing statistics about its usage.

Collection and reset context

Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.

Inspect this field

Example query; no execution result or measured value is asserted.

SELECT spill_bytes FROM pg_catalog.pg_stat_replication_slots;

Related entries

• pg_stat_replication_slots columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 13 → 14: added.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1 +1,6 @@
-Not recorded in this version
+{
+  "field": "spill_bytes",
+  "sql_type": "bigint",
+  "units_mentioned": [],
+  "view": "pg_stat_replication_slots"
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• pg_stat_replication_slots.slot_name
• pg_stat_replication_slots.spill_count
• pg_stat_replication_slots.spill_txns
• pg_stat_replication_slots.stats_reset
• pg_stat_replication_slots.stream_bytes
• pg_stat_replication_slots.stream_count
• pg_stat_replication_slots.stream_txns
• pg_stat_replication_slots.total_bytes
• pg_stat_replication_slots.total_txns