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

Column	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).

last updated: 2025-09-11 15:37 UTC - commit: 0936b7736854a5d1860e596c7749139402140c8a