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

GLOBAL_WAL_SENDER_STATUS

GLOBAL_WAL_SENDER_STATUS displays the redo log transfer and replay status of the primary DN in the current cluster. This view can be viewed only by the users with monitor admin and sysadmin permission.

Table 1 GLOBAL_WAL_SENDER_STATUS column

Name

Type

Description

nodename

text

Name of the primary node

source_ip

text

IP address of the primary node

source_port

integer

Port of the primary node

dest_ip

text

IP address of the standby node

dest_port

integer

Port of the standby node

sender_pid

integer

PID of the sending thread

local_role

text

Type of the primary node

peer_role

text

Type of the standby node

peer_state

text

Status of the standby node

state

text

WAL sender status

sender_sent_location

text

Sending position of the primary node

sender_write_location

text

Writing position of the primary node

sender_flush_location

text

Flushing position of the primary node

sender_replay_location

text

Redo position of the primary node

receiver_received_location

text

Receiving position of the standby node

receiver_write_location

text

Writing position of the standby node

receiver_flush_location

text

Flushing location of the standby node

receiver_replay_location

text

Redo location of the standby node