{"Entry":{"collection":"catalog","key":"pg_stat_subscription_stats","name":"pg_stat_subscription_stats","aliases":[],"metadata":{"changed_in":["18","19"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"14","order":false,"removed":[],"status":"added","to":"15","types":[]},{"added":["confl_insert_exists","confl_update_origin_differs","confl_update_exists","confl_update_missing","confl_delete_origin_differs","confl_delete_missing","confl_multiple_unique_conflicts"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Number of times an error occurred while applying changes","name":"apply_error_count","to":"Number of times an error occurred while applying changes. Note that any conflict resulting in an apply error will be counted in both apply_error_count and the corresponding conflict count (e.g., confl_*)."}],"from":"17","listing":[],"order":false,"removed":[],"status":"changed","to":"18","types":[],"unlisted":[]},{"added":["sync_seq_error_count","sync_table_error_count","confl_update_deleted"],"attributes":[],"description_changed":false,"descriptions":[],"from":"18","listing":[],"order":false,"removed":["sync_error_count"],"status":"changed","to":"19","types":[],"unlisted":[]}],"column_count":14,"content_hash":"63a47d2463d719ac9aea0b0be923d6e2f53f9eaffa4459ede1a6afecfde2c12c","first_version":"15","imported_at":"2026-09-30T00:40:55.993602+08:00","kind":"statistics","last_version":"20","name":"pg_stat_subscription_stats","position":109,"present_in":["15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:07c4de75a13df1b3c54bdaf39d73b0edb13d77d0e32357fdc438cb43a954b918","summary":"The pg_stat_subscription_stats view will contain one row per subscription.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_subscription_stats","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_subscription_stats","SourceRevision":"english-manuals:07c4de75a13df1b3c54bdaf39d73b0edb13d77d0e32357fdc438cb43a954b918","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the subscription","description_zh":"","documented":true,"documented_name":"subid","hidden":false,"name":"subid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"Name of the subscription","description_zh":"","documented":true,"documented_name":"subname","hidden":false,"name":"subname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"Number of times an error occurred while applying changes. Note that any conflict resulting in an apply error will be counted in both apply_error_count and the corresponding conflict count (e.g., confl_*).","description_zh":"","documented":true,"documented_name":"apply_error_count","hidden":false,"name":"apply_error_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":4,"description":"Number of times an error occurred during the initial table synchronization","description_zh":"","documented":true,"documented_name":"sync_error_count","hidden":false,"name":"sync_error_count","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":5,"description":"Number of times a row insertion violated a NOT DEFERRABLE unique constraint during the application of changes. See insert_exists for details about this conflict.","description_zh":"","documented":true,"documented_name":"confl_insert_exists","hidden":false,"name":"confl_insert_exists","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":6,"description":"Number of times an update was applied to a row that had been previously modified by another source during the application of changes. See update_origin_differs for details about this conflict.","description_zh":"","documented":true,"documented_name":"confl_update_origin_differs","hidden":false,"name":"confl_update_origin_differs","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":7,"description":"Number of times that an updated row value violated a NOT DEFERRABLE unique constraint during the application of changes. See update_exists for details about this conflict.","description_zh":"","documented":true,"documented_name":"confl_update_exists","hidden":false,"name":"confl_update_exists","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":8,"description":"Number of times the tuple to be updated was not found during the application of changes. See update_missing for details about this conflict.","description_zh":"","documented":true,"documented_name":"confl_update_missing","hidden":false,"name":"confl_update_missing","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":9,"description":"Number of times a delete operation was applied to row that had been previously modified by another source during the application of changes. See delete_origin_differs for details about this conflict.","description_zh":"","documented":true,"documented_name":"confl_delete_origin_differs","hidden":false,"name":"confl_delete_origin_differs","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":10,"description":"Number of times the tuple to be deleted was not found during the application of changes. See delete_missing for details about this conflict.","description_zh":"","documented":true,"documented_name":"confl_delete_missing","hidden":false,"name":"confl_delete_missing","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":11,"description":"Number of times a row insertion or an updated row values violated multiple NOT DEFERRABLE unique constraints during the application of changes. See multiple_unique_conflicts for details about this conflict.","description_zh":"","documented":true,"documented_name":"confl_multiple_unique_conflicts","hidden":false,"name":"confl_multiple_unique_conflicts","not_null":false,"references":"","type":"bigint","type_modifier":-1,"type_oid":20},{"array_dimensions":0,"attnum":12,"description":"Time at which these statistics were last reset","description_zh":"","documented":true,"documented_name":"stats_reset","hidden":false,"name":"stats_reset","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184}],"description":"The pg_stat_subscription_stats view will contain one row per subscription.","description_zh":"","doc":{"anchor":"PG-STAT-SUBSCRIPTION-STATS","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"kind":"statistics","lang":"en","measured_attributes":true,"metadata_release":"18.6","runtime_columns":["subid","subname","apply_error_count","sync_error_count","confl_insert_exists","confl_update_origin_differs","confl_update_exists","confl_update_missing","confl_delete_origin_differs","confl_delete_missing","confl_multiple_unique_conflicts","stats_reset"],"runtime_verified":false,"source":"english-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-SUBSCRIPTION-STATS","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"measured_attributes":true,"metadata_release":"18.6","runtime_columns":["subid","subname","apply_error_count","sync_error_count","confl_insert_exists","confl_update_origin_differs","confl_update_exists","confl_update_missing","confl_delete_origin_differs","confl_delete_missing","confl_multiple_unique_conflicts","stats_reset"],"runtime_verified":false}},"Text":{"Collection":"catalog","Key":"pg_stat_subscription_stats","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_subscription_stats","Summary":"pg_stat_subscription_stats视图将包含每个订阅的一行。","BodyHTML":"\u003cp\u003epg_stat_subscription_stats视图将包含每个订阅的一行。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"c47502bf277bac6188ecdf04ba00975ed64870c3741493a6840896930232f5b3","Payload":{"columns":[{"description_zh":"订阅的OID","name":"subid","type":"oid","zh_from":"doc"},{"description_zh":"订阅的名称","name":"subname","type":"name","zh_from":"doc"},{"description_zh":"应用更改时发生错误的次数。请注意，导致应用错误的任何冲突都会同时计入 apply_error_count 和对应的冲突计数（例如 confl_*）。","name":"apply_error_count","type":"bigint","zh_from":"doc"},{"description_zh":"在初始表同步期间发生错误的次数","name":"sync_error_count","type":"bigint","zh_from":"doc"},{"description_zh":"在应用更改期间，行插入违反 NOT DEFERRABLE 唯一约束的次数。有关该冲突的详细信息，请参阅insert_exists。","name":"confl_insert_exists","type":"bigint","zh_from":"doc"},{"description_zh":"在应用更改期间，更新被应用到先前已被另一个源修改过的行上的次数。有关该冲突的详细信息，请参阅update_origin_differs。","name":"confl_update_origin_differs","type":"bigint","zh_from":"doc"},{"description_zh":"在应用更改期间，更新后的行值违反 NOT DEFERRABLE 唯一约束的次数。有关该冲突的详细信息，请参阅update_exists。","name":"confl_update_exists","type":"bigint","zh_from":"doc"},{"description_zh":"在应用更改期间，待更新的元组未找到的次数。有关该冲突的详细信息，请参阅update_missing。","name":"confl_update_missing","type":"bigint","zh_from":"doc"},{"description_zh":"在应用更改期间，删除操作被应用到先前已被另一个源修改过的行上的次数。有关该冲突的详细信息，请参阅delete_origin_differs。","name":"confl_delete_origin_differs","type":"bigint","zh_from":"doc"},{"description_zh":"在应用更改期间，待删除的元组未找到的次数。有关该冲突的详细信息，请参阅delete_missing。","name":"confl_delete_missing","type":"bigint","zh_from":"doc"},{"description_zh":"在应用更改期间，行插入或更新后的行值违反多个 NOT DEFERRABLE 唯一约束的次数。有关该冲突的详细信息，请参阅multiple_unique_conflicts。","name":"confl_multiple_unique_conflicts","type":"bigint","zh_from":"doc"},{"description_zh":"这些统计信息上次被重置的时间","name":"stats_reset","type":"timestamp with time zone","zh_from":"doc"}],"description_zh":"pg_stat_subscription_stats视图将包含每个订阅的一行。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}