Re: auto_explain and parallel queries issue

2018-04-16 Thread Pavel Stehule
2018-04-16 10:33 GMT+02:00 Tomas Vondra :

>
>
> On 04/16/2018 09:25 AM, Pavel Stehule wrote:
> > Hi
> >
> > I am testing PostgreSQL in customer's environment and I found some
> > unexpected behave.
> >
> > When auto_explain is used, and there is slower parallel query, then
> > auto_explain raises log for any slow process.
> >
>
> FWIW this is the same issue that I reported in 2016:
>
> https://www.postgresql.org/message-id/3f62f24e-51b3-175c-
> 9222-95f25fd2a9d6%402ndquadrant.com


yes. The fix should not be too hard. The report can do only process who
owns query text

Regards

Pavel


>
>
> regards
>
> --
> Tomas Vondra  http://www.2ndQuadrant.com
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>


Re: auto_explain and parallel queries issue

2018-04-16 Thread Tomas Vondra


On 04/16/2018 09:25 AM, Pavel Stehule wrote:
> Hi
> 
> I am testing PostgreSQL in customer's environment and I found some
> unexpected behave.
> 
> When auto_explain is used, and there is slower parallel query, then
> auto_explain raises log for any slow process.
> 

FWIW this is the same issue that I reported in 2016:

https://www.postgresql.org/message-id/3f62f24e-51b3-175c-9222-95f25fd2a9d6%402ndquadrant.com

regards

-- 
Tomas Vondra  http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services