49.68. 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 Chapter 47.

Table 49-69. pg_replication_origin_status Columns

local_idOidpg_replication_origin.roidentinternal node identifier
external_idtextpg_replication_origin.ronameexternal node identifier
remote_lsnpg_lsn The origin node's LSN up to which data has been replicated.
local_lsnpg_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.