pg_stat_replication_slots.total_bytes

Description

Amount of transaction data decoded for sending transactions to the decoding output plugin while decoding changes from WAL for this slot. Note that this includes data that is streamed and/or spilled.

View

pg_stat_replication_slots

Field

total_bytes

SQL type

bigint

Units named in the field definition

transactions

Reset observation

Time at which these statistics were last reset

Usage

SELECT total_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 total_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,8 @@
-Not recorded in this version
+{
+  "field": "total_bytes",
+  "sql_type": "bigint",
+  "units_mentioned": [
+    "transactions"
+  ],
+  "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_bytes
• 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_txns