gp_stat_replication
The gp_stat_replication view contains replication statistics of the WAL sender process that is used for Greengage DB write-ahead logging (WAL) replication when master or segment mirroring is enabled.
| Column | Type | Description |
|---|---|---|
gp_segment_id |
integer |
Unique identifier of a segment (or master) instance |
pid |
integer |
Process ID of the WAL sender backend process |
usesysid |
oid |
User system ID that runs the WAL sender backend process |
usename |
name |
User name that runs the WAL sender 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 with time zone |
Operation start timestamp |
backend_xmin |
xid |
The current backend’s |
state |
text |
WAL sender state.
The value can be: |
sent_location |
pg_lsn |
WAL sender xlog record sent location |
write_location |
pg_lsn |
WAL receiver xlog record write location |
flush_location |
pg_lsn |
WAL receiver xlog record flush location |
replay_location |
pg_lsn |
Master standby or segment mirror xlog record replay location |
sync_priority |
integer |
Priority.
The value is |
sync_state |
text |
WAL sender synchronization state.
The value is |
sync_error |
text |
WAL sender synchronization error.
|