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

GLOBAL_RECOVERY_STATUS

GLOBAL_RECOVERY_STATUS displays log flow control information about the primary and standby nodes, as described in Table 1.

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).