gp_stat_replication
gp_stat_replication视图包含walsender进程的复制统计信息，该进程在启用master或segment镜像时用于Greenplum数据库预写日志记录（WAL）复制。
Table 1. gp_catalog.gp_stat_replication
| 列 | 类型 | 参考 | 描述 |
|---|---|---|---|
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. |
Parent topic: 系统目录定义