Thread: proposal: interprocess EXPLAIN PID
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.On Fri, Apr 11, 2014 at 12:13 PM, Pavel Stehule <pavel.stehule@gmail.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
Hello
2014-04-13 7:16 GMT+02:00 Amit Kapila <amit.kapila16@gmail.com>:
On Fri, Apr 11, 2014 at 12:13 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:Does this mean that you want to track plan (and other info Explain
> Hello
>
> I propose a enhancing of EXPLAIN statement about possibility get a plan of
> other PostgreSQL process.
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