Lu, Huayi
e6fa411af0
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
11 KiB
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.
Name |
Type |
Description |
|---|---|---|
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 |
Start time of the program |
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) |