Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query
Дата
Msg-id B8834F26-229F-4B0A-A06F-885795F005E1@yesql.se
обсуждение исходный текст
Ответ на New function pg_stat_statements_reset_query() to reset statistics ofa specific query  (Haribabu Kommi <kommi.haribabu@gmail.com>)
Список pgsql-hackers
> On 20 Jun 2018, at 09:30, Haribabu Kommi <kommi.haribabu@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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Haribabu Kommi
Дата:
Сообщение: New function pg_stat_statements_reset_query() to reset statistics ofa specific query
Следующее
От: Amit Langote
Дата:
Сообщение: Re: ToDo: show size of partitioned table