Updated on 2023-10-23 GMT+08:00

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

integer

ID of the background Apply thread.

received_lsn

text

Latest LSA received from the publisher.

last_msg_send_time

timestamp with time zone

Time when the last message is sent.

last_msg_receipt_time

timestamp with time zone

Time when the last message is received by the subscriber.

latest_end_lsn

text

LSN of the sender when the last keepalive message is received.

latest_end_time

timestamp with time zone

Time when the last keepalive message is received.