Re: Profile what the production server is doing - Mailing list pgsql-performance

From Julien Rouhaud
Subject Re: Profile what the production server is doing
Date
Msg-id CAOBaU_b311By9X5=V8brkfgsg=xkSV4kcpGHvz=MH=+-=UFQyg@mail.gmail.com
Whole thread Raw
In response to Re: Profile what the production server is doing  (Thomas Güttler <guettliml@thomas-guettler.de>)
Responses Automated bottleneck detection  (Thomas Güttler <guettliml@thomas-guettler.de>)
List pgsql-performance
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.


pgsql-performance by date:

Previous
From: Flo Rance
Date:
Subject: Re: Profile what the production server is doing
Next
From: Thomas Güttler
Date:
Subject: Automated bottleneck detection