Automated bottleneck detection

From: Thomas Güttler
Subject: Automated bottleneck detection
Date: ,
Msg-id: 14b51a31-df17-62ab-1b00-778cce29e57d@thomas-guettler.de
(view: Whole thread, Raw)
In response to: Re: Profile what the production server is doing  (Julien Rouhaud)
Responses: Re: Automated bottleneck detection  (MichaelDBA)
List: pgsql-performance

Tree view

Profile what the production server is doing  (Thomas Güttler, )
 Re: Profile what the production server is doing  (Julien Rouhaud, )
  Re: Profile what the production server is doing  (Thomas Güttler, )
   Re: Profile what the production server is doing  (Julien Rouhaud, )
    Automated bottleneck detection  (Thomas Güttler, )
     Re: Automated bottleneck detection  (MichaelDBA, )
 Re: Profile what the production server is doing  (Baron Schwartz, )
  Re: Profile what the production server is doing  (Thomas Güttler, )
 Re: Profile what the production server is doing  (Flo Rance, )
  Re: Profile what the production server is doing  (Thomas Güttler, )
   Re: Profile what the production server is doing  (Flo Rance, )

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.
>> 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



pgsql-performance by date:

From: Matthew Hall
Date:
Subject: Re: Query with "ILIKE ALL" does not use the index
From: Nicolas Even
Date:
Subject: Re: Query with "ILIKE ALL" does not use the index