gp_stat_replication
The gp_stat_replication view contains replication statistics of the walsender process that is used for SynxDB 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. | |
backend_xmin | xid | The current backend’s xmin horizon. | |
state | text | walsender state. The value can be:startupbackupcatchupstreaming | |
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. |