Re: pg_stat_reset_single_*_counters vs pg_stat_database.stats_reset

Hi,

On 2022-03-23 17:55:16 -0700, Andres Freund wrote:
> Maybe I just don't understand what these reset functions are intended for?
> Their introduction [3] didn't explain much either. To me the behaviour of
> resetting pg_stat_database.stats_reset but nothing else in pg_stat_database
> makes them kind of dangerous.

Forgot to add: At the very least we should document that weird behaviour,
because it's certainly not obvious.  But imo we should either remove the
behaviour or drop the functions.

      
       
        
         pg_stat_reset_single_table_counters
        
        pg_stat_reset_single_table_counters ( oid )
        void
       
       
        Resets statistics for a single table or index in the current database
        or shared across all databases in the cluster to zero.
       
       
        This function is restricted to superusers by default, but other users
        can be granted EXECUTE to run the function.
       
      

      
       
        
         pg_stat_reset_single_function_counters
        
        pg_stat_reset_single_function_counters ( oid )
        void
       
       
        Resets statistics for a single function in the current database to
        zero.
       
       
        This function is restricted to superusers by default, but other users
        can be granted EXECUTE to run the function.
       
      


Greetings,

Andres Freund