pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAutomated bottleneck detection
2+ messages / 2 participants
[nested] [flat]
* Automated bottleneck detection
@ 2018-07-26 11:27 Thomas Güttler <guettliml@thomas-guettler.de>
0 siblings, 1 reply; 2+ messages in thread
From: Thomas Güttler @ 2018-07-26 11:27 UTC (permalink / raw)
To: pgsql-performance@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Automated bottleneck detection
@ 2018-07-26 12:05 MichaelDBA <MichaelDBA@sqlexec.com>
parent: Thomas Güttler <guettliml@thomas-guettler.de>
0 siblings, 0 replies; 2+ messages in thread
From: MichaelDBA @ 2018-07-26 12:05 UTC (permalink / raw)
To: Thomas Güttler <guettliml@thomas-guettler.de>; +Cc: pgsql-performance@lists.postgresql.org
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 <mailto:guettliml@thomas-guettler.de>
> Thursday, July 26, 2018 7:27 AM
> This sound good. Looks like an automated bootleneck detection
> could be possible with pg_wait_sampling.
>
> Regards,
> Thomas
>
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-07-26 12:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-26 11:27 Automated bottleneck detection Thomas Güttler <guettliml@thomas-guettler.de>
2018-07-26 12:05 ` MichaelDBA <MichaelDBA@sqlexec.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox