pg_stat_subscription_stats 是一个 统计视图，显示有关逻辑复制订阅错误的信息。
pg_stat_subscription_stats 在 PostgreSQL 15 中添加。
按 PostgreSQL 版本定义
pg_stat_subscription_stats (PostgreSQL 17)
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 | | |
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 | | |
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 | | |
更改历史记录
示例
发生应用错误后 pg_stat_subscription_stats 的示例内容
postgres=# SELECT * FROM pg_stat_subscription_stats; subid | subname | apply_error_count | sync_error_count | stats_reset -------+----------+-------------------+------------------+------------- 16392 | test_sub | 1 | 0 | (1 row)
相应的日志条目是
ERROR: 23505: duplicate key value violates unique constraint "foo_pkey" DETAIL: Key (id)=(6) already exists. CONTEXT: processing remote data for replication origin "pg_16392" during message type "INSERT" for replication target relation "public.foo" in transaction 730, finished at 0/2508608
参考文献
- PostgreSQL 文档： pg_stat_subscription_stats