RE: Adding percentile metrics to pg_stat_statements module
| От | benoit |
|---|---|
| Тема | RE: Adding percentile metrics to pg_stat_statements module |
| Дата | |
| Msg-id | 4c77f9cfb35149b5a245c8a7ef6923f0@hopsandfork.com обсуждение исходный текст |
| Ответ на | Re: Adding percentile metrics to pg_stat_statements module (Adrien Nayrat <adrien.nayrat@anayrat.info>) |
| Список | pgsql-hackers |
Hello
While looking at slow queries on pg_stat_statements. I was looking for percentile fields..
If we are worried about CPU cost, maybe it could be useful to turn in on when you have a high stddev_exec_time for the query ?
Regards,
De : Adrien Nayrat <adrien.nayrat@anayrat.info>
Envoyé : samedi 2 novembre 2019 10:23:49
À : Tomas Vondra; Igor Calabria
Cc : pgsql-hackers@postgresql.org
Objet : Re: Adding percentile metrics to pg_stat_statements module
Envoyé : samedi 2 novembre 2019 10:23:49
À : Tomas Vondra; Igor Calabria
Cc : pgsql-hackers@postgresql.org
Objet : Re: Adding percentile metrics to pg_stat_statements module
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
> 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 по дате отправления: