New function pg_stat_statements_reset_query() to reset statistics ofa specific query

Поиск
Список
Период
Сортировка
От Haribabu Kommi
Тема New function pg_stat_statements_reset_query() to reset statistics ofa specific query
Дата
Msg-id CAJrrPGcyh-gkFswyc6C661K6cknL0XkNqVT0sQt2mFNMR4HRKA@mail.gmail.com
обсуждение исходный текст
Ответы Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query  (Daniel Gustafsson <daniel@yesql.se>)
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query  (Jeremy Schneider <schneider@ardentperf.com>)
Re: New function pg_stat_statements_reset_query() to reset statistics of a specific query  (Sergei Kornilov <sk@zsrv.org>)
Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query  (Euler Taveira <euler@timbira.com.br>)
Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query  (Ashutosh Sharma <ashu.coek88@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
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
Вложения

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: ToDo: show size of partitioned table
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: New function pg_stat_statements_reset_query() to reset statisticsof a specific query