Updated on 2024-06-03 GMT+08:00

global_streaming_hadr_rto_and_rpo_stat

global_streaming_hadr_rto_and_rpo_stat displays the log flow control information about the primary and standby clusters for streaming DR, as described in Table 1. (This view can be used only on the CN in the primary cluster and cannot obtain statistics from the DN or standby cluster.)

Table 1 Parameters

Parameter

Type

Description

hadr_sender_node_name

text

Name of the first standby node in the primary and standby clusters.

hadr_receiver_node_name

text

Name of the first standby node in the standby cluster.

current_rto

int

Flow control information, that is, log RTO time of the current primary and standby clusters (unit: second). -1 indicates that the majority of the DR cluster is abnormal.

target_rto

int

Flow control information, that is, RTO time between the target primary and standby clusters (unit: second).

current_rpo

int

Flow control information, that is, log RPO time of the current primary and standby clusters (unit: second) -1 indicates that the majority of the DR cluster is abnormal.

target_rpo

int

Flow control information, that is, RPO time between the target primary and standby clusters (unit: second).

rto_sleep_time

int

RTO flow control information, that is, expected sleep time (unit: μs) required by WAL sender on the host to reach the specified RTO.

rpo_sleep_time

int

RPO flow control information, that is, expected sleep time (unit: μs) required by xlogInsert on the host to reach the specified RPO.