This sound good. Looks like an automated bootleneck detection
could be possible with pg_wait_sampling.
Regards,
Thomas
Am 25.07.2018 um 12:25 schrieb Julien Rouhaud:
> On Wed, Jul 25, 2018 at 11:14 AM, Thomas Güttler
> <guettliml@thomas-guettler.de> wrote:
>>
>> AFAIK powa is based on pg_stat_statements not on statistical samples.
>> But maye I am wrong.
>
> Indeed, it's based on pg_stat_statements, but other extensions are
> supported too. Since pg_stat_statements already provides cumulated
> counters, there's no need to do sampling. But if you're interested in
> wait events information for instance, it supports (in development
> version) pg_wait_sampling extension, which does sampling to provide
> efficient and informative informations.
>
--
Thomas Guettler http://www.thomas-guettler.de/
I am looking for feedback: https://github.com/guettli/programming-guidelines