51.79. 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.80. 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.

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.

51.77. pg_prepared_xacts

54. System Views

Last modified 7mo ago