Postgres Pro
Downloads
Home   >   mailing lists

Re: auto_explain and parallel queries issue - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: auto_explain and parallel queries issue
Date
Msg-id CAFj8pRCh5CjOh7h1tLmdtQGnp1w10h2kSyeQovX0gS4tZZNzNw@mail.gmail.com
Whole thread Raw
In response to Re: auto_explain and parallel queries issue  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Tree view


2018-04-16 10:33 GMT+02:00 Tomas Vondra <tomas.vondra@2ndquadrant.com>:


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

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: auto_explain and parallel queries issue
Next
From: Yugo Nagata
Date:
Subject: Re: [HACKERS] [PATCH] Lockable views