目录

pg_stat_subscription_stats

显示逻辑复制订阅错误的视图

pg_stat_subscription_stats 是一个显示有关逻辑复制订阅错误信息的统计视图。

pg_stat_subscription_stats 在 PostgreSQL 15 中添加。

用法

如果在订阅者上启用了 track_commit_timestamp（PostgreSQL 18 及更高版本），则以下列将更新。

  • confl_update_origin_differs
  • confl_delete_origin_differs

按 PostgreSQL 版本定义

pg_stat_subscription_stats (PostgreSQL 18)

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

文档: pg_stat_subscription_stats

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

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

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

变更历史

  • PostgreSQL 18
    • 添加以下列 (提交 6c2b5ede)
      • confl_insert_exists
      • confl_update_origin_differs
      • confl_update_exists
      • confl_update_missing
      • confl_delete_origin_differs
      • confl_delete_missing
  • PostgreSQL 15
    • 添加 (提交 8d74fc96，最初为 pg_stat_subscription_workers，但在 7a850732 中重命名)

示例

发生应用错误后 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

分类

逻辑复制，统计/监控视图，系统目录

另请参阅

pg_stat_subscription

反馈

提交任何关于"pg_stat_subscription_stats"的评论、建议或更正 此处。