PG_STAT_REPLICATION

PG_STAT_REPLICATION displays information about log synchronization status, such as the locations of the sender sending logs and the receiver receiving logs.

**Table 1** PG_STAT_REPLICATION columns
Name	Type	Description
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).