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.