Skip to main content
Version: 2.x

pg_replication_origin_status

The pg_replication_origin_status view provides information about the progress of replication origins, including the local and remote log sequence numbers (LSNs). This view is essential for monitoring and managing logical replication synchronization.

nametypereferencesdescription
local_idoidpg_replication_origin.roidentInternal node identifier.
external_idtextpg_replication_origin.ronameExternal node identifier.
remote_lsnpg_lsnThe origin node's LSN up to which data has been replicated.
local_lsnpg_lsnThis node's LSN at which remote_lsn has been replicated. Used to flush commit records before persisting data to disk when using asynchronous commits.