| Lists: | pgsql-hackers |
|---|
| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | proposal: interprocess EXPLAIN PID |
| Date: | 2014-04-11 06:43:36 |
| Message-ID: | CAFj8pRDE_-ATo1fpEr-VnyOCzEm=oATJFb_1uN90hTjLHkgFpQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hello
I propose a enhancing of EXPLAIN statement about possibility get a plan of
other PostgreSQL process. With some other enhancing this technique can be
interesting for monitoring long duration queries.
Notes, comments?
Regards
Pavel Stehule
| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal: interprocess EXPLAIN PID |
| Date: | 2014-04-13 05:16:51 |
| Message-ID: | CAA4eK1KY6mMrhuzDX1AkbPJ15bN-W4gfiv5JxEdGBOW--GmDVw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
On Fri, Apr 11, 2014 at 12:13 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> Hello
>
> I propose a enhancing of EXPLAIN statement about possibility get a plan of
> other PostgreSQL process.
Does this mean that you want to track plan (and other info Explain
provides) of statements running in particular backend?
Could you please explain this in bit more detail w.r.t how this will work?
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal: interprocess EXPLAIN PID |
| Date: | 2014-04-13 10:24:45 |
| Message-ID: | CAFj8pRA5FkY519Ers4qxOPb=sk8QWi8gKXtU0VGztODUPZ-FEw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Hello
2014-04-13 7:16 GMT+02:00 Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>:
> On Fri, Apr 11, 2014 at 12:13 PM, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
> wrote:
> > Hello
> >
> > I propose a enhancing of EXPLAIN statement about possibility get a plan
> of
> > other PostgreSQL process.
>
> Does this mean that you want to track plan (and other info Explain
> provides) of statements running in particular backend?
> Could you please explain this in bit more detail w.r.t how this will work?
>
for 9.5 I plan to implement a plain EXPLAIN only. Any other improvements
can be append incrementally.
Regards
Pavel
>
> With Regards,
> Amit Kapila.
> EnterpriseDB: http://www.enterprisedb.com
>