pg_stat_subscription_stats.confl_delete_missing

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.

View

pg_stat_subscription_stats

Field

confl_delete_missing

SQL type

bigint

Units named in the field definition

Not specified

Reset observation

Time at which these statistics were last reset

Usage

SELECT confl_delete_missing FROM pg_catalog.pg_stat_subscription_stats;

View semantics

The pg_stat_subscription_stats view will contain one row per subscription.

Collection and reset context

Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.

Inspect this field

Example query; no execution result or measured value is asserted.

SELECT confl_delete_missing FROM pg_catalog.pg_stat_subscription_stats;

Related entries

• pg_stat_subscription_stats columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 17 → 18: added.

--- PostgreSQL 17
+++ PostgreSQL 18
@@ -1 +1,6 @@
-Not recorded in this version
+{
+  "field": "confl_delete_missing",
+  "sql_type": "bigint",
+  "units_mentioned": [],
+  "view": "pg_stat_subscription_stats"
+}

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• pg_stat_subscription_stats.apply_error_count
• pg_stat_subscription_stats.confl_delete_origin_differs
• pg_stat_subscription_stats.confl_insert_exists
• pg_stat_subscription_stats.confl_multiple_unique_conflicts
• pg_stat_subscription_stats.confl_update_exists
• pg_stat_subscription_stats.confl_update_missing
• pg_stat_subscription_stats.confl_update_origin_differs
• pg_stat_subscription_stats.stats_reset
• pg_stat_subscription_stats.subid
• pg_stat_subscription_stats.subname
• pg_stat_subscription_stats.sync_error_count