Updated on 2023-10-23 GMT+08:00

GLOBAL_RECOVERY_STATUS

GLOBAL_RECOVERY_STATUS displays log flow control information about the primary and standby nodes.

Table 1 GLOBAL_RECOVERY_STATUS columns

Name

Type

Description

node_name

text

Node name (including the primary and standby nodes)

standby_node_name

text

Name of the standby node

source_ip

text

IP address of the primary node

source_port

integer

Port number of the primary node

dest_ip

text

IP address of the standby node

dest_port

integer

Port number of the standby node

current_rto

bigint

Current log flow control time of the standby node (unit: s)

target_rto

bigint

Expected flow control time of the standby node specified by the corresponding GUC parameter (unit: s)

current_sleep_time

bigint

Sleep time required to achieve the expected flow control time (unit: μs)