| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: auto_explain and parallel queries issue |
| Date: | 2018-04-16 08:37:36 |
| Message-ID: | CAFj8pRCh5CjOh7h1tLmdtQGnp1w10h2kSyeQovX0gS4tZZNzNw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
2018-04-16 10:33 GMT+02:00 Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yugo Nagata | 2018-04-16 08:41:16 | Re: [HACKERS] [PATCH] Lockable views |
| Previous Message | Tomas Vondra | 2018-04-16 08:33:20 | Re: auto_explain and parallel queries issue |