pg_replication_origin_status
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.
Definition by PostgreSQL version
pg_replication_origin_status (PostgreSQL 16)
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 15)
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 14)
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 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
- PostgreSQL 9.5
- added (commit 5aa23504).
pg_replication_origin_status has not been modified since it was added in PostgreSQL 9.5.
Examples
Sample contents of pg_replication_origin_status on a logical replication subscriber:
postgres=# SELECT * FROM pg_replication_origin_status;
local_id | external_id | remote_lsn | local_lsn
----------+---------------------------------------+------------+------------
1 | pgl_app_app_provider_app_subscription | 7/56A6A80 | 3/5D7767A0
(1 row)
References
- PostgreSQL documentation: pg_replication_origin_status