gp_stat_replication
gp_stat_replication
gp_stat_replication视图包含walsender进程的复制统计信息，该进程在启用master或segment镜像时用于Greenplum数据库预写日志记录（WAL）复制。
| 列 | 类型 | 参考 | 描述 |
|---|---|---|---|
| gp_segment_id | integer | segment（或master）实例的唯一标识符。 | |
| pid | integer | walsender后端进程的进程ID。 | |
| usesysid | oid | 运行walsender后端进程的用户系统标识。 | |
| usename | name | 运行walsender后端进程的用户名。 | |
| application_name | text | 客户端应用名称。 | |
| client_addr | inet | 客户端IP地址。 | |
| client_hostname | text | 客户端主机名。 | |
| client_port | integer | 客户端端口号。 | |
| backend_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. |