Re: Profile what the production server is doing

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Profile what the production server is doing
Дата
Msg-id CAOBaU_b311By9X5=V8brkfgsg=xkSV4kcpGHvz=MH=+-=UFQyg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Profile what the production server is doing  (Thomas Güttler <guettliml@thomas-guettler.de>)
Ответы Automated bottleneck detection  (Thomas Güttler <guettliml@thomas-guettler.de>)
Список 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 по дате отправления:

Предыдущее
От: Flo Rance
Дата:
Сообщение: Re: Profile what the production server is doing
Следующее
От: Thomas Güttler
Дата:
Сообщение: Automated bottleneck detection