53.19. pg_replication_origin_status

pg_replication_origin_status

The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed. For more on replication origins see Replication Progress Tracking.

Column Type Description
local_id `oid` (references pg_replication_origin.roident) internal node identifier
external_id `text` (references pg_replication_origin.roname) external node identifier
remote_lsn `pg_lsn` The origin node's LSN up to which data has been replicated.
local_lsn `pg_lsn` This node's LSN at which `remote_lsn` has been replicated. Used to flush commit records before persisting data to disk when using asynchronous commits.

Column Type

Description

local_id oid (references pg_replication_origin.roident)

internal node identifier

external_id text (references pg_replication_origin.roname)

external node identifier

remote_lsn pg_lsn

The origin node's LSN up to which data has been replicated.

local_lsn pg_lsn

This node's LSN at which remote_lsn has been replicated. Used to flush commit records before persisting data to disk when using asynchronous commits.

: pg_replication_origin_status Columns