PGXC_STAT_REPLICATION

PGXC_STAT_REPLICATION displays the log synchronization status of each node in the cluster. All columns except node_name are the same as those in the PG_STAT_REPLICATION view. This view is accessible only to users with system administrators rights.

Table 1 PGXC_STAT_REPLICATION columns

Column

Type

Description

node_name

Text

Node name

pid

Bigint

PID of the thread

usesysid

OID

User system ID

usename

Name

Username

application_name

Text

Program name

client_addr

inet

Client address

client_hostname

Text

Client name

client_port

Integer

Client port number

backend_start

Timestamp with time zone

Program start time

state

Text

Log replication state (catch-up or consistent streaming)

sender_sent_location

Text

Location where the sender sends logs

receiver_write_location

Text

Location where the receiver writes logs

receiver_flush_location

Text

Location where the receiver flushes logs

receiver_replay_location

Text

Location where the receiver replays logs

sync_priority

Integer

Priority of synchronous duplication (0 indicates asynchronization)

sync_state

Text

Synchronization state (asynchronous duplication, synchronous duplication, or potential synchronization)