SYSTEM CATALOGS / SYSTEM VIEWS
pg_replication_origin_status
Read PG 18 manual ↗The pg_replication_origin_status view contains information about how far replay for a certain origin has progressed.
- Kind
- System views
- Columns in this snapshot
- 4
- Definition source
- English manual
Columns 4
| 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
- PG 16 → 17changed
- PG 13 → 14changed
- PG 11 → 12changed
- PG 10 → 11changed
- PG 9.6 → 10changed
- PG 9.5 → 9.6changed
- PG 9.4 → 9.5added
Definition snapshot: english-manuals:bc4201b596ab5604bf8894fb95e… · English manual source