New function pg_stat_statements_reset_query() to reset statistics of a specific query
Haribabu Kommi <kommi.haribabu@gmail.com>
From: Haribabu Kommi <kommi.haribabu@gmail.com>
To: Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2018-06-20T07:30:31Z
Lists: pgsql-hackers
Attachments
- 0001-Function-to-reset-statistics-of-a-specific-statement.patch (application/octet-stream) patch 0001
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? Regards, Haribabu Kommi Fujitsu Australia
Commits
-
Extend pg_stat_statements_reset to reset statistics specific to a
- 43cbedab8ff1 12.0 landed
-
Default monitoring roles
- 25fff40798fc 10.0 cited