Home Explore Blog CI



postgresql

28th chunk of `doc/src/sgml/monitoring.sgml`
82f91cbe0ac70fca825d20ee051a6aa5103fa196ebfaa2600000000100000fa1
 occurred while applying changes. Note that any
       conflict resulting in an apply error will be counted in both
       <literal>apply_error_count</literal> and the corresponding conflict
       count (e.g., <literal>confl_*</literal>).
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>sync_error_count</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times an error occurred during the initial table
       synchronization
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>confl_insert_exists</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times a row insertion violated a
       <literal>NOT DEFERRABLE</literal> unique constraint during the
       application of changes. See <xref linkend="conflict-insert-exists"/>
       for details about this conflict.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>confl_update_origin_differs</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times an update was applied to a row that had been previously
       modified by another source during the application of changes. See
       <xref linkend="conflict-update-origin-differs"/> for details about this
       conflict.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>confl_update_exists</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times that an updated row value violated a
       <literal>NOT DEFERRABLE</literal> unique constraint during the
       application of changes. See <xref linkend="conflict-update-exists"/>
       for details about this conflict.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>confl_update_missing</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times the tuple to be updated was not found during the
       application of changes. See <xref linkend="conflict-update-missing"/>
       for details about this conflict.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>confl_delete_origin_differs</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times a delete operation was applied to row that had been
       previously modified by another source during the application of changes.
       See <xref linkend="conflict-delete-origin-differs"/> for details about
       this conflict.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>confl_delete_missing</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times the tuple to be deleted was not found during the application
       of changes. See <xref linkend="conflict-delete-missing"/> for details
       about this conflict.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>confl_multiple_unique_conflicts</structfield> <type>bigint</type>
      </para>
      <para>
       Number of times a row insertion or an updated row values violated multiple
       <literal>NOT DEFERRABLE</literal> unique constraints during the
       application of changes. See <xref linkend="conflict-multiple-unique-conflicts"/>
       for details about this conflict.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>stats_reset</structfield> <type>timestamp with time zone</type>
      </para>
      <para>
       Time at which

Title: pg_stat_subscription_stats: Conflict Statistics Columns
Summary
This section details the conflict statistics columns in the `pg_stat_subscription_stats` view. It describes columns that track various types of conflicts encountered during data replication, including conflicts related to insert, update, and delete operations. Specifically, it covers conflicts arising from unique constraint violations (`confl_insert_exists`, `confl_update_exists`, `confl_multiple_unique_conflicts`), data discrepancies (`confl_update_origin_differs`, `confl_delete_origin_differs`), and missing tuples (`confl_update_missing`, `confl_delete_missing`). It also includes `stats_reset`, tracking when the statistics were last reset.