gp_stat_replication

gp_stat_replication

The gp_stat_replication view contains replication statistics of the walsender process that is used for Greenplum Database Write-Ahead Logging (WAL) replication when master or segment mirroring is enabled.

Table 1. gp_catalog.gp_stat_replication
column type references description
gp_segment_id integer   Unique identifier of a segment (or master) instance.
pid integer   Process ID of the walsender backend process.
usesysid oid   User system ID that runs the walsender backend process.
usename name   User name that runs the walsender backend process.
application_name text   Client application name.
client_addr inet   Client IP address.
client_hostname text   Client host name.
client_port integer   Client port number.
backend_start timestamp   Operation start timestamp.
state text   walsender state. The value can be:

startup

backup

catchup

streaming

sent_location text   walsender xlog record sent location.
write_location text   walreceiver xlog record write location.
flush_location text   walreceiver xlog record flush location.
replay_location text   Master standby or segment mirror xlog record replay location.
sync_priority integer   Priority. The value is 1.
sync_state text   walsendersynchronization state. The value is sync.
sync_error text   walsender synchronization error. none if no error.