pg_stat_subscription

A statistics view showing logical replication subscriptions

pg_stat_subscription is a statistics view showing logical replication subscriptions.

pg_stat_subscription was added in PostgreSQL 10 (commit 665d1fad).

Definition by PostgreSQL version

pg_stat_subscription (PostgreSQL 13)

                      View "pg_catalog.pg_stat_subscription"
        Column         |           Type           | Collation | Nullable | Default
-----------------------+--------------------------+-----------+----------+---------
 subid                 | oid                      |           |          |
 subname               | name                     |           |          |
 pid                   | integer                  |           |          |
 relid                 | oid                      |           |          |
 received_lsn          | pg_lsn                   |           |          |
 last_msg_send_time    | timestamp with time zone |           |          |
 last_msg_receipt_time | timestamp with time zone |           |          |
 latest_end_lsn        | pg_lsn                   |           |          |
 latest_end_time       | timestamp with time zone |           |          |
    

Documentation: pg_stat_subscription

pg_stat_subscription (PostgreSQL 12)

                      View "pg_catalog.pg_stat_subscription"
        Column         |           Type           | Collation | Nullable | Default
-----------------------+--------------------------+-----------+----------+---------
 subid                 | oid                      |           |          |
 subname               | name                     |           |          |
 pid                   | integer                  |           |          |
 relid                 | oid                      |           |          |
 received_lsn          | pg_lsn                   |           |          |
 last_msg_send_time    | timestamp with time zone |           |          |
 last_msg_receipt_time | timestamp with time zone |           |          |
 latest_end_lsn        | pg_lsn                   |           |          |
 latest_end_time       | timestamp with time zone |           |          |
    

Documentation: pg_stat_subscription

pg_stat_subscription (PostgreSQL 11)

                      View "pg_catalog.pg_stat_subscription"
        Column         |           Type           | Collation | Nullable | Default
-----------------------+--------------------------+-----------+----------+---------
 subid                 | oid                      |           |          |
 subname               | name                     |           |          |
 pid                   | integer                  |           |          |
 relid                 | oid                      |           |          |
 received_lsn          | pg_lsn                   |           |          |
 last_msg_send_time    | timestamp with time zone |           |          |
 last_msg_receipt_time | timestamp with time zone |           |          |
 latest_end_lsn        | pg_lsn                   |           |          |
 latest_end_time       | timestamp with time zone |           |          |
    

Documentation: pg_stat_subscription

pg_stat_subscription (PostgreSQL 10)

                      View "pg_catalog.pg_stat_subscription"
        Column         |           Type           | Collation | Nullable | Default
-----------------------+--------------------------+-----------+----------+---------
 subid                 | oid                      |           |          |
 subname               | name                     |           |          |
 pid                   | integer                  |           |          |
 relid                 | oid                      |           |          |
 received_lsn          | pg_lsn                   |           |          |
 last_msg_send_time    | timestamp with time zone |           |          |
 last_msg_receipt_time | timestamp with time zone |           |          |
 latest_end_lsn        | pg_lsn                   |           |          |
 latest_end_time       | timestamp with time zone |           |          |
    

Documentation: pg_stat_subscription

Change history

Categories

Statistics / monitoring view