System Catalogs / System views
pg_replication_origin_status
Read the PG 18 manualThe pg_replication_origin_status view contains information about how far replay for a certain origin has progressed.
Reading PG 18current·documented in 13 of 24 versions, 9.5 to 20
- Kind
- System views
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
local_id | oid | internal node identifier pg_replication_origin.roident |
external_id | text | external node identifier pg_replication_origin.roname |
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 history across versions
Version history 7
Definition snapshot: english-manuals:90752284ef86a80c96cd69b2008… · English manual source