Re: Adding percentile metrics to pg_stat_statements module
Adrien Nayrat <adrien.nayrat@anayrat.info>
From: Adrien Nayrat <adrien.nayrat@anayrat.info>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>, Igor Calabria <igor.calabria@gmail.com>
Cc: <pgsql-hackers@postgresql.org>
Date: 2019-11-02T09:23:49Z
Lists: 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