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. |