Re: Profile what the production server is doing

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Thomas Güttler <guettliml(at)thomas-guettler(dot)de>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Profile what the production server is doing
Date: 2018-07-25 10:25:49
Message-ID: CAOBaU_b311By9X5=V8brkfgsg=xkSV4kcpGHvz=MH=+-=UFQyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jul 25, 2018 at 11:14 AM, Thomas Güttler
<guettliml(at)thomas-guettler(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Thomas Güttler 2018-07-26 11:27:38 Automated bottleneck detection
Previous Message Flo Rance 2018-07-25 09:49:51 Re: Profile what the production server is doing