Wiki / Statistics & Metrics

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

documented

true

field

stream_txns

manual path

/docs/18/monitoring-stats.html

signature

SELECT stream_txns FROM pg_catalog.pg_stat_replication_slots;

source only

false

sql type

bigint

units mentioned

transactions

view

pg_stat_replication_slots