`pg_replication_origin_status`
note
This mirror of official PostgreSQL documentation is brought to you by Neon with ❤️
Not all information is applicable to Neon. See Postgres compatibility for details.
Not all information is applicable to Neon. See Postgres compatibility for details.
54.18. 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 50.
Table 54.18. pg_replication_origin_status Columns
| Column TypeDescription |
|---|
local_id oid (references pg_replication_origin.roident)internal node identifier |
external_id text (references pg_replication_origin.roname)external node identifier |
remote_lsn pg_lsnThe origin node's LSN up to which data has been replicated. |
local_lsn pg_lsnThis node's LSN at which remote_lsn has been replicated. Used to flush commit records before persisting data to disk when using asynchronous commits. |