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	OID of the subscription.
subname	name	Name of the subscription.
pid	thread_id	ID of the background Apply thread.
received_lsn	LSN	Latest LSN received from the publisher.
last_msg_send_time	timestamp	Time when the last message is sent from the publisher.
last_msg_receipt_time	timestamp	Time when the last message is received by the subscriber.
latest_end_lsn	LSN	LSN of the publisher when the last keepalive message is received.
latest_end_time	timestamp	Time when the last keepalive message is received.

PG_STAT_SUBSCRIPTION ​