Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements

Поиск
Список
Период
Сортировка
Искать
От
Andrei Zubkov
Тема
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements
Дата
Msg-id
00cc23ddbe5c26bb5cc9a9aaebe4a1e1367f6bab.camel@moonset.ru
Ответ на
Список
Дерево обсуждения
[PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud <rjuju123@gmail.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Seino Yuki <seinoyu@oss.nttdata.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements "kuroda.hayato@fujitsu.com" <kuroda.hayato@fujitsu.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Julien Rouhaud <rjuju123@gmail.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Chengxi Sun <sunchengxi@highgo.com>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re[2]: [PATCH] Tracking statements entry timestamp in pg_stat_statements Мельников Антон Андреевич <aamelnikov@inbox.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements Andrei Zubkov <zubkov@moonset.ru>
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements "Anton A. Melnikov" <aamelnikov@inbox.ru>
Hi

On Fri, 2022-03-25 at 00:37 -0400, Greg Stark wrote:
> Fwiw I find the idea of having a separate "aux" table kind of
> awkward.
> It'll seem strange to users not familiar with the history and without
> any clear idea why the fields are split.

Greg, thank you for your attention and for your thought.

I've just completed the 6th version of a patch implementing idea
proposed by Julien Rouhaud, i.e. without auxiliary statistics. 6th
version will reset current min/max fields to zeros until the first plan
or execute. I've decided to use zeros here because planning statistics
is zero in case of disabled tracking. I think sampling solution could
easily handle this.

-- 
Regards, Andrei Zubkov

В списке pgsql-hackers по дате отправления
От: wangw.fnst@fujitsu.com
Дата:
От: Tomas Vondra
Дата:
FAQ