pg_stat_subscription

• 17
• 16
• 15
• 14
• 13
• 12
• 11
• 10

                      View "pg_catalog.pg_stat_subscription"
        Column         |           Type           | Collation | Nullable | Default 
-----------------------+--------------------------+-----------+----------+---------
 subid                 | oid                      |           |          | 
 subname               | name                     |           |          | 
 worker_type           | text                     |           |          | 
 pid                   | integer                  |           |          | 
 leader_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 |           |          |
    

                      View "pg_catalog.pg_stat_subscription"
        Column         |           Type           | Collation | Nullable | Default 
-----------------------+--------------------------+-----------+----------+---------
 subid                 | oid                      |           |          | 
 subname               | name                     |           |          | 
 pid                   | integer                  |           |          | 
 leader_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 |           |          |
    

                      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 |           |          |
    

                      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 |           |          |
    

                      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 |           |          |
    

                      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 |           |          |
    

                      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 |           |          |
    

                      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 |           |          |
    

pg_stat_subscription 的示例内容

postgres=# SELECT * FROM pg_stat_subscription;
-[ RECORD 1 ]---------+------------------------------
subid                 | 16404
subname               | test_subscription
pid                   | 6436
relid                 | 
received_lsn          | 0/14ED8B8
last_msg_send_time    | 2021-11-24 16:02:04.801319+01
last_msg_receipt_time | 2021-11-24 16:02:04.801549+01
latest_end_lsn        | 0/14ED8B8
latest_end_time       | 2021-11-24 16:02:04.801319+01

• PostgreSQL 文档： pg_stat_subscription