pg_stat_replication
The pg_stat_replication view contains metadata of the WAL sender process that is used for Greengage DB master mirroring.
The gp_stat_replication view contains WAL sender replication information for master and segment mirroring.
| Column | Type | Description |
|---|---|---|
pid |
integer |
Process ID of 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 |
The host name of the client machine |
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 |
Standby xlog record replay location |
sync_priority |
integer |
Priority.
The value is |
sync_state |
text |
WAL sender synchronization state.
The value is |