Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ GLOBAL_WAL_SENDER_STATUS
Updated on 2025-08-19 GMT+08:00
View PDF

GLOBAL_WAL_SENDER_STATUS

GLOBAL_WAL_SENDER_STATUS displays the redo log transfer and replay status of the primary DN in the current cluster. Only the user with the SYSADMIN or MONADMIN permission can query this view.

Table 1 GLOBAL_WAL_SENDER_STATUS columns

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

  • UNKNOWN_MODE: The status is unknown.
  • NORMAL_MODE: single-host node type.
  • PRIMARY_MODE: The node is a primary node.
  • STANDBY_MODE: The node is a standby node.
  • CASCADE_STANDBY_MODE: The node is a cascaded standby node.
  • PENDING_MODE: The node is in the arbitration phase.
  • RECOVERY_MODE: The node is in the restoration phase.
  • STANDBY_CLUSTER_MODE: The node is a standby cluster node.
  • MAIN_STANDBY_MODE: main standby cluster node.
NOTE:

The expected values of the primary node type are NORMAL_MODE, PRIMARY_MODE, PENDING_MODE, and RECOVERY_MODE. Contact Huawei technical support if other node types are displayed.

peer_role

text

Type of the standby node

  • UNKNOWN_MODE: The status is unknown.
  • NORMAL_MODE: single-host node type.
  • PRIMARY_MODE: The node is a primary node.
  • STANDBY_MODE: The node is a standby node.
  • CASCADE_STANDBY_MODE: The node is a cascaded standby node.
  • PENDING_MODE: The node is in the arbitration phase.
  • RECOVERY_MODE: The node is in the restoration phase.
  • STANDBY_CLUSTER_MODE: The node is a standby cluster node.
  • MAIN_STANDBY_MODE: main standby cluster node.
NOTE:

The expected values of the standby node type are NORMAL_MODE, STANDBY_MODE, CASCADE_STANDBY_MODE, PENDING_MODE, RECOVERY_MODE, STANDBY_CLUSTER_MODE, and MAIN_STANDBY_MODE. If other node types are displayed, contact Huawei technical support.

peer_state

text

Status of the standby node

  • UNKNOWN_STATE: The node status is unknown.
  • NORMAL_STATE: The node is started properly.
  • NEEDREPAIR_STATE: The current node needs to be repaired.
  • STARTING_STATE: The node is being started.
  • WAITING_STATE: The node is waiting to be upgraded.
  • DEMOTING_STATE: The node is being downgraded.
  • PROMOTING_STATE: The standby node is being upgraded to the primary node.
  • BUILDING_STATE: The standby node fails to be started and needs to be rebuilt.
  • CATCHUP_STATE: The standby node is catching up with the primary node.
  • COREDUMP_STATE: The node breaks down.

state

text

WAL sender status

  • WALSNDSTATE_STARTUP: startup state.
  • WALSNDSTATE_BACKUP: backup state.
  • WALSNDSTATE_CATCHUP: catch-up state.
  • WALSNDSTATE_STREAMING: streaming replication state.

sender_sent_location

text

Sending position of the primary node

sender_write_location

text

Writing position of the primary node

sender_flush_location

text

Location where the master node writes the cache to the disk.

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

Location where the standby node writes the cache to the disk.

receiver_replay_location

text

Redo location of the standby node
Parent topic: Other System Views