> On 20 Jun 2018, at 09:30, Haribabu Kommi <kommi.harib...@gmail.com> wrote: > > The pg_stat_statements contains the statistics of the queries that are > cumulative. > I find that any optimizations that are done to improve the performance of a > query > are not be visible clearly until the stats are reset. Currently there is a > function to > reset all the statistics, I find it will be useful if we a function that > resets the stats of > a single query, instead of reseting all the queries.
I’ve found myself wanting this in the past, so +1 on the idea. > Attached is a simple patch with implementation. Comments? From only skimming it, the patch seems to lack documentation updates to doc/src/sgml/pgstatstatements.sgml. cheers ./daniel