pg_stat_subscription_stats

A view showing logical replication subscription statistics

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

                 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

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

PostgreSQL 15
- added (commit 8d74fc96, initially as pg_stat_subscription_workers but renamed in 7a850732)

Examples

References

PostgreSQL documentation: pg_stat_subscription_stats

Version charts

Useful overviews

Useful links

Contents