• Amit Kapila's avatar
    Extend pg_stat_statements_reset to reset statistics specific to a · 43cbedab
    Amit Kapila authored
    particular user/db/query.
    
    The function pg_stat_statements_reset() is extended to accept userid, dbid,
    and queryid as input parameters.  Now, it can discard the statistics
    gathered so far by pg_stat_statements corresponding to the specified
    userid, dbid, and queryid.  If no parameter is specified or all the
    specified parameters have default value aka 0, it will discard all
    statistics as per the old behavior.
    
    The new behavior is useful to get the fresh statistics for a specific
    user/database/query without resetting all the existing statistics.
    
    Author: Haribabu Kommi, with few additional changes by me
    Reviewed-by: Michael Paquier, Amit Kapila and Fujii Masao
    Discussion: https://postgr.es/m/CAJrrPGcyh-gkFswyc6C661K6cknL0XkNqVT0sQt2mFNMR4HRKA@mail.gmail.com
    43cbedab
pg_stat_statements.sql 5.96 KB