Historical version. PostgreSQL 9.6 has reached end of support. 2021-11-11. See the current manual.
50.70. 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 50-71. 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. |
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.