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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- local_id, external_id, remote_lsn, local_lsn
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| local_id | oid | Nullable | internal node identifier |
| external_id | text | Nullable | external node identifier |
| remote_lsn | pg_lsn | Nullable | The origin node's LSN up to which data has been replicated. |
| local_lsn | pg_lsn | Nullable | 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. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:9c3a8c6c3e2975979e20fc64b3989efc4d6d1906dc0e01ef53f9f09ed8d6909f
Text language: en · catalog-bilingual-repair:9c3a8c6c3e2975979e20fc64b3989efc4d6d1906dc0e01ef53f9f09ed8d6909f