pg_stat_subscription_stats

A view showing logical replication subscription statistics
This entry relates to a PostgreSQL feature which is part of PostgreSQL 15, due to be released in late 2022.

pg_stat_subscription_stats is a statistics view showing information about logical replication subscriptions.

pg_stat_subscription_stats was added in PostgreSQL 15.

Definition by PostgreSQL version

pg_stat_subscription_stats (PostgreSQL 15)

                 View "pg_catalog.pg_stat_subscription_stats"
      Column       |           Type           | Collation | Nullable | Default 
-------------------+--------------------------+-----------+----------+---------
 subid             | oid                      |           |          | 
 subname           | name                     |           |          | 
 apply_error_count | bigint                   |           |          | 
 sync_error_count  | bigint                   |           |          | 
 stats_reset       | timestamp with time zone |           |          |
    

Documentation: pg_stat_subscription_stats

Change history

Examples

 

Categories

Logical replication, Statistics / monitoring view, System catalogue

See also

pg_stat_subscription