gp_stat_replication
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
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.
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. |