pg_stat_replication.state

Description

Current WAL sender state. Possible values are: startup: This WAL sender is starting up. catchup: This WAL sender's connected standby is catching up with the primary. streaming: This WAL sender is streaming changes after its connected standby server has caught up with the primary. backup: This WAL sender is sending a backup. stopping: This WAL sender is stopping.

View

pg_stat_replication

Field

state

SQL type

text

Units named in the field definition

Not specified

Reset observation

No stats_reset field is documented for this view

Usage

SELECT state FROM pg_catalog.pg_stat_replication;

View semantics

The pg_stat_replication view will contain one row per WAL sender process, showing statistics about replication to that sender's connected standby server. Only directly connected standbys are listed; no information is available about downstream standby servers.

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 state FROM pg_catalog.pg_stat_replication;

Related entries

• pg_stat_replication columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 17 → 18: unchanged.

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.application_name
• pg_stat_replication.backend_start
• pg_stat_replication.backend_xmin
• pg_stat_replication.client_addr
• pg_stat_replication.client_hostname
• pg_stat_replication.client_port
• pg_stat_replication.flush_lag
• pg_stat_replication.flush_lsn
• pg_stat_replication.pid
• pg_stat_replication.replay_lag
• pg_stat_replication.replay_lsn
• pg_stat_replication.reply_time