pg_replication_origin_status
The pg_replication_origin_status view provides information about the progress of replication origins, including the local and remote log sequence numbers (LSNs). This view is essential for monitoring and managing logical replication synchronization.
| 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. |