GLOBAL_REPLICATION_STAT

GLOBAL_REPLICATION_STAT displays information about log synchronization status on each node, such as the locations where the sender sends logs and where the receiver receives logs, as described in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB. Currently, PDB-level log synchronization is not supported. Therefore, an empty list is returned.

**Table 1** GLOBAL_REPLICATION_STAT columns
Name	Type	Description
node_name	name	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	Port of the client.
backend_start	timestamp with time zone	Start time of the program.
state	text	Log replication state: Catch-up state Consistent streaming state
sender_sent_location	text	Location where the transmit sends logs.
receiver_write_location	text	Location where the receive end writes logs.
receiver_flush_location	text	Location where the receive end flushes logs.
receiver_replay_location	text	Location where the receive end replays logs.
sync_priority	integer	Priority of synchronous duplication (0 indicates asynchronization.)
sync_state	text	Synchronization state: Asynchronous replication Synchronous replication Potential synchronization
dbid	oid	Database ID.