Updated on 2023-10-23 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. (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 of 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).

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)

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.