Skip to content

pg_stat_replication

The pg_stat_replication view contains metadata of the walsender process that is used for WarehousePG coordinator mirroring.

The gp_stat_replication view contains walsender replication information for coordinator and segment mirroring.

columntypereferencesdescription
pidintegerProcess ID of WAL sender backend process.
usesysidintegerUser system ID that runs the WAL sender backend process
usenamenameUser name that runs WAL sender backend process.
application_nameoidClient application name.
client_addrnameClient IP address.
client_hostnametextThe host name of the client machine.
client_portintegerClient port number.
backend_starttimestampOperation start timestamp.
backend_xminxidThe current backend's xmin horizon.
statetextWAL sender state. The value can be:

startup

backup

catchup

streaming
sent_locationtextWAL sender xlog record sent location.
write_locationtextWAL receiver xlog record write location.
flush_locationtextWAL receiver xlog record flush location.
replay_locationtextStandby xlog record replay location.
sync_prioritytextPriority. the value is 1.
sync_statetextWAL sender synchronization state. The value is sync.

Parent topic: System Catalogs Definitions