On Wed, Jun 20, 2018 at 1:00 PM, 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. > > Attached is a simple patch with implementation. Comments?
The idea looks interesting to me. But, as Euler Taveira mentioned, can't we extend an existing function pg_stat_statements_reset() instead of adding a new one and update the documentation for it. Also, in the test-case it would be good to display the output of pg_stat_statements before and after deleting the query. Thanks. -- With Regards, Ashutosh Sharma EnterpriseDB:http://www.enterprisedb.com