Home Explore Blog CI



postgresql

29th chunk of `doc/src/sgml/monitoring.sgml`
63f1eea6b55cc9c6686f73ea766f14b5066f066c22f5c6b80000000100000fa4
 <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 these statistics were last reset
      </para></entry>
     </row>
    </tbody>
   </tgroup>
  </table>

 </sect2>

 <sect2 id="monitoring-pg-stat-ssl-view">
  <title><structname>pg_stat_ssl</structname></title>

  <indexterm>
   <primary>pg_stat_ssl</primary>
  </indexterm>

  <para>
   The <structname>pg_stat_ssl</structname> view will contain one row per
   backend or WAL sender process, showing statistics about SSL usage on
   this connection. It can be joined to <structname>pg_stat_activity</structname>
   or <structname>pg_stat_replication</structname> on the
   <structfield>pid</structfield> column to get more details about the
   connection.
  </para>

  <table id="pg-stat-ssl-view" xreflabel="pg_stat_ssl">
   <title><structname>pg_stat_ssl</structname> View</title>
   <tgroup cols="1">
    <thead>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       Column Type
      </para>
      <para>
       Description
      </para></entry>
     </row>
    </thead>

    <tbody>
     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>pid</structfield> <type>integer</type>
      </para>
      <para>
       Process ID of a backend or WAL sender process
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>ssl</structfield> <type>boolean</type>
      </para>
      <para>
       True if SSL is used on this connection
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>version</structfield> <type>text</type>
      </para>
      <para>
       Version of SSL in use, or NULL if SSL is not in use
       on this connection
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>cipher</structfield> <type>text</type>
      </para>
      <para>
       Name of SSL cipher in use, or NULL if SSL is not in use
       on this connection
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>bits</structfield> <type>integer</type>
      </para>
      <para>
       Number of bits in the encryption algorithm used, or NULL
       if SSL is not used on this connection
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>client_dn</structfield> <type>text</type>
      </para>
      <para>
       Distinguished Name (DN) field from the client certificate
       used, or NULL if no client certificate was supplied or if SSL
       is not in use on this connection. This field is truncated if the
       DN field is longer than <symbol>NAMEDATALEN</symbol> (64 characters
       in a standard build).
      </para></entry>
     </row>

     <row>

Title: pg_stat_subscription_stats and pg_stat_ssl Views
Summary
This section describes the `pg_stat_subscription_stats` view, focusing on the `confl_delete_missing`, `confl_multiple_unique_conflicts`, and `stats_reset` columns. It then introduces the `pg_stat_ssl` view, which provides statistics about SSL usage for each backend or WAL sender process. The `pg_stat_ssl` view's structure and columns, including information like process ID, SSL usage status, SSL version, cipher, bits, and client distinguished name, are detailed. The pg_stat_ssl view can be joined with pg_stat_activity and pg_stat_replication views.