Extend pg_stat_statements_reset to reset statistics specific to a
authorAmit Kapila <akapila@postgresql.org>
Fri, 11 Jan 2019 03:20:09 +0000 (08:50 +0530)
committerAmit Kapila <akapila@postgresql.org>
Fri, 11 Jan 2019 03:20:09 +0000 (08:50 +0530)
commit43cbedab8ff1eef4088807ffc1a64a107de67af6
treee4d54a3498e71f165c04432f846dd86c78b6ee45
parent3b174b1a355f0de2d433c16eb350b3356bdd08b8
Extend pg_stat_statements_reset to reset statistics specific to a
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
contrib/pg_stat_statements/Makefile
contrib/pg_stat_statements/expected/pg_stat_statements.out
contrib/pg_stat_statements/pg_stat_statements--1.6--1.7.sql [new file with mode: 0644]
contrib/pg_stat_statements/pg_stat_statements.c
contrib/pg_stat_statements/pg_stat_statements.control
contrib/pg_stat_statements/sql/pg_stat_statements.sql
doc/src/sgml/pgstatstatements.sgml