Home Explore Blog CI



postgresql

59th chunk of `doc/src/sgml/monitoring.sgml`
2800dd64b591d8eaec4b4dffe793352ce218254940aad3fd0000000100000fb3
 <para>
        This function is restricted to superusers by default, but other users
        can be granted EXECUTE to run the function.
       </para></entry>
      </row>

      <row>
       <entry role="func_table_entry"><para role="func_signature">
        <indexterm>
         <primary>pg_stat_reset_single_table_counters</primary>
        </indexterm>
        <function>pg_stat_reset_single_table_counters</function> ( <type>oid</type> )
        <returnvalue>void</returnvalue>
       </para>
       <para>
        Resets statistics for a single table or index in the current database
        or shared across all databases in the cluster to zero.
       </para>
       <para>
        This function is restricted to superusers by default, but other users
        can be granted EXECUTE to run the function.
       </para></entry>
      </row>

      <row>
       <entry role="func_table_entry"><para role="func_signature">
        <indexterm>
         <primary>pg_stat_reset_backend_stats</primary>
        </indexterm>
        <function>pg_stat_reset_backend_stats</function> ( <type>integer</type> )
        <returnvalue>void</returnvalue>
       </para>
       <para>
        Resets statistics for a single backend with the specified process ID
        to zero.
       </para>
       <para>
        This function is restricted to superusers by default, but other users
        can be granted EXECUTE to run the function.
       </para></entry>
      </row>

      <row>
       <entry role="func_table_entry"><para role="func_signature">
        <indexterm>
         <primary>pg_stat_reset_single_function_counters</primary>
        </indexterm>
        <function>pg_stat_reset_single_function_counters</function> ( <type>oid</type> )
        <returnvalue>void</returnvalue>
       </para>
       <para>
        Resets statistics for a single function in the current database to
        zero.
       </para>
       <para>
        This function is restricted to superusers by default, but other users
        can be granted EXECUTE to run the function.
       </para></entry>
      </row>

      <row>
       <entry role="func_table_entry"><para role="func_signature">
        <indexterm>
         <primary>pg_stat_reset_slru</primary>
        </indexterm>
        <function>pg_stat_reset_slru</function> ( [ <parameter>target</parameter> <type>text</type> <literal>DEFAULT</literal> <literal>NULL</literal> ] )
        <returnvalue>void</returnvalue>
       </para>
       <para>
        Resets statistics to zero for a single SLRU cache, or for all SLRUs in
        the cluster. If <parameter>target</parameter> is
        <literal>NULL</literal> or is not specified, all the counters shown in
        the <structname>pg_stat_slru</structname> view for all SLRU caches are
        reset. The argument can be one of
        <literal>commit_timestamp</literal>,
        <literal>multixact_member</literal>,
        <literal>multixact_offset</literal>,
        <literal>notify</literal>,
        <literal>serializable</literal>,
        <literal>subtransaction</literal>, or
        <literal>transaction</literal>
        to reset the counters for only that entry.
        If the argument is <literal>other</literal> (or indeed, any
        unrecognized name), then the counters for all other SLRU caches, such
        as extension-defined caches, are reset.
       </para>
       <para>
        This function is restricted to superusers by default, but other users
        can be granted EXECUTE to run the function.
       </para></entry>
      </row>

      <row>
       <entry role="func_table_entry"><para role="func_signature">
        <indexterm>
          <primary>pg_stat_reset_replication_slot</primary>
        </indexterm>
        <function>pg_stat_reset_replication_slot</function> ( <type>text</type> )
        <returnvalue>void</returnvalue>
       </para>
       <para>
        Resets statistics of the replication slot defined by the argument. If
        the argument is <literal>NULL</literal>,

Title: PostgreSQL Statistics Functions (Continued): Fine-Grained Statistics Reset
Summary
This section describes more functions for resetting statistics in PostgreSQL. `pg_stat_reset_single_table_counters` resets statistics for a specific table or index. `pg_stat_reset_backend_stats` resets statistics for a specific backend process ID. `pg_stat_reset_single_function_counters` resets statistics for a single function. `pg_stat_reset_slru` resets statistics for a specific SLRU cache or all SLRU caches. All these functions are restricted to superusers by default, but others can be granted EXECUTE permission.