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 47.
Table 49-69. pg_replication_origin_status Columns
|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.|