pg_replication_origin_status
A system catalogue view showing the approximate state of replay for a certain origin
pg_replication_origin_status is a system catalogue view showing the approximate state of replay for a certain origin. It is based on the underlying system catalogue table pg_replication_origin.
pg_replication_origin_status was added in PostgreSQL 9.5 (commit 5aa23504).
Definition by PostgreSQL version
pg_replication_origin_status (PostgreSQL 13)
View "pg_catalog.pg_replication_origin_status"
Column | Type | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
local_id | oid | | |
external_id | text | | |
remote_lsn | pg_lsn | | |
local_lsn | pg_lsn | | |
Documentation: pg_replication_origin_status
pg_replication_origin_status (PostgreSQL 12)
View "pg_catalog.pg_replication_origin_status"
Column | Type | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
local_id | oid | | |
external_id | text | | |
remote_lsn | pg_lsn | | |
local_lsn | pg_lsn | | |
Documentation: pg_replication_origin_status
pg_replication_origin_status (PostgreSQL 11)
View "pg_catalog.pg_replication_origin_status"
Column | Type | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
local_id | oid | | |
external_id | text | | |
remote_lsn | pg_lsn | | |
local_lsn | pg_lsn | | |
Documentation: pg_replication_origin_status
pg_replication_origin_status (PostgreSQL 10)
View "pg_catalog.pg_replication_origin_status"
Column | Type | Collation | Nullable | Default
-------------+--------+-----------+----------+---------
local_id | oid | | |
external_id | text | | |
remote_lsn | pg_lsn | | |
local_lsn | pg_lsn | | |
Documentation: pg_replication_origin_status
pg_replication_origin_status (PostgreSQL 9.6)
View "pg_catalog.pg_replication_origin_status"
Column | Type | Modifiers
-------------+--------+-----------
local_id | oid |
external_id | text |
remote_lsn | pg_lsn |
local_lsn | pg_lsn |
Documentation: pg_replication_origin_status
pg_replication_origin_status (PostgreSQL 9.5)
View "pg_catalog.pg_replication_origin_status"
Column | Type | Modifiers
-------------+--------+-----------
local_id | oid |
external_id | text |
remote_lsn | pg_lsn |
local_lsn | pg_lsn |
Documentation: pg_replication_origin_status
Change history
This view has remained unchanged since its introduction in PostgreSQL 9.5.
- PostgreSQL 9.5
- added (commit 5aa23504).
References
- PostgreSQL documentation: pg_replication_origin_status