pg_stat_replication_slots.stream_txns · Statistics & Metrics

Description

Number of in-progress transactions streamed to the decoding output plugin after the memory used by logical decoding to decode changes from WAL for this slot has exceeded logical_decoding_work_mem. Streaming only works with top-level transactions (subtransactions can't be streamed independently), so the counter is not incremented for subtransactions.

View: pg_stat_replication_slots
Field: stream_txns
SQL type: bigint
Units named in the field definition: transactions
Reset observation: Time at which these statistics were last reset

Usage

SELECT stream_txns 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 stream_txns FROM pg_catalog.pg_stat_replication_slots;

Related entries

Documentation and source

PostgreSQL 18 English manual

Source build

Version: 18.6
Build: https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
Source fingerprint: 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Compare versions

PostgreSQL 13 → 14: added.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1 +1,8 @@
-Not recorded in this version
+{
+  "field": "stream_txns",
+  "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.