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 49.
Table 51.81. pg_replication_origin_status Columns
| Name | Type | References | Description |
|---|---|---|---|
local_id | Oid | | internal node identifier |
external_id | text | | 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.
|