Re: Adding percentile metrics to pg_stat_statements module

Поиск
Список
Период
Сортировка
От Adrien Nayrat
Тема Re: Adding percentile metrics to pg_stat_statements module
Дата
Msg-id c07d7cdd-620a-82b3-a876-c95403c005ca@anayrat.info
обсуждение исходный текст
Ответ на Re: Adding percentile metrics to pg_stat_statements module  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы RE: Adding percentile metrics to pg_stat_statements module  (benoit <benoit@hopsandfork.com>)
Список pgsql-hackers
On 10/31/19 8:32 PM, Tomas Vondra wrote:
> IMO having some sort of CDF approximation (being a q-digest or t-digest)
> would be useful, although it'd probably need to be optional (mostly
> becuase of memory consumption).

+1, I like this idea. If we are afraid of CPU cost we could imagine some kind of
sampling or add the possibility to collect only for a specific queryid.

I dreamed of this kind of feature for PoWA.  Thus, it could make possible to
compare CDF between two days for example, before and after introducing a change.

Regards,

-- 
Adrien NAYRAT




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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: [Proposal] Global temporary tables
Следующее
От: Andrey Borodin
Дата:
Сообщение: Re: pglz performance