↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5
Pre-release documentation. PostgreSQL 19 Beta 3 is a testing release. The final release may differ.
53.21. pg_replication_origin_status
Prev  Up Chapter 53. System Views Home  Next

53.21. 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 48.

Table 53.21. pg_replication_origin_status Columns

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.

Prev  Up  Next
53.20. pg_publication_tables  Home  53.22. pg_replication_slots

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.