PGXC_STAT_REPLICATION

Updated on 2024-12-19 GMT+08:00

View PDF

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. Only users with system administrator permissions can access this view.

**Table 1** **PGXC_STAT_REPLICATION** columns
Name	Type	Description
node_name	text	Node name
pid	bigint	PID of the thread
usesysid	oid	User system ID
usename	name	Username
application_name	text	Application 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)