PG_STAT_SUBSCRIPTION
PG_STAT_SUBSCRIPTION displays the detailed synchronization information about the subscription.
Table 1 PG_STAT_SUBSCRIPTION columns
Name
|
Type
|
Description
|
|---|
subid
|
oid
|
Subscription OID.
|
subname
|
name
|
Subscription name.
|
pid
|
thread_id
|
ID of the background Apply thread.
|
received_lsn
|
LSN
|
Latest LSA received from the publisher.
|
last_msg_send_time
|
timestamp
|
Time when the last message is sent.
|
last_msg_receipt_time
|
timestamp
|
Time when the last message is received by the subscriber.
|
latest_end_lsn
|
LSN
|
LSN of the sender when the last keepalive message is received.
|
latest_end_time
|
timestamp
|
Time when the last keepalive message is received.
|