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