November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
52.79. pg_replication_origin_status
Prev  Up Chapter 52. System Catalogs Home  Next

52.79. 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 50.

Table 52.80. pg_replication_origin_status Columns

Name Type References Description
local_id Oid pg_replication_origin.roident internal node identifier
external_id text 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.

Prev  Up  Next
52.78. pg_publication_tables  Home  52.80. pg_replication_slots