Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ RTO & RPO/ global_streaming_hadr_rto_and_rpo_stat

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

View PDF

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.