pg_stat_replication

The pg_stat_replication view contains metadata of the walsender process that is used for Greenplum Database master mirroring.

column type references description
procpid integer Process ID of WAL sender backend process.
usesysid integer User system ID that runs the WAL sender backend process
usename name User name that runs WAL sender backend process.
application_name oid Client application name.
client_addr name Client IP address.
client_port integer Client port number.
backend_start timestamp Operation start timestamp.
state text WAL sender state.
The value can be:
startup
backup
catchup
streaming
sent_location text WAL sender xlog record sent location.
write_location text WAL receiver xlog record write location.
flush_location text WAL receiver xlog record flush location.
replay_location text Standby xlog record replay location.
sync_priority text Priorty. the value is 1.
sync_state text WAL sender syncronization state. The value is sync.

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon