Re: Automated bottleneck detection

2018-07-26 Thread MichaelDBA
Wow, freakin cool, can't wait to start fiddling with pg_wait_sampling. Reckon we can get lightweight locks and spinlocks history with this cool new extension instead of awkwardly and repeatedly querying the pg_stat_activity table. Regards, Michael Vitale Thomas Güttler

Automated bottleneck detection

2018-07-26 Thread Thomas Güttler
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 wrote: AFAIK powa is based on pg_stat_statements not on statistical samples