Wiki / Statistics & Metrics

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

documented

true

field

state

manual path

/docs/18/monitoring-stats.html

signature

SELECT state FROM pg_catalog.pg_stat_replication;

source only

false

sql type

text

units mentioned

Unknown

view

pg_stat_replication