Postgres Pro
Downloads
Home   >   mailing lists

Thread: proposal: interprocess EXPLAIN PID

proposal: interprocess EXPLAIN PID

From
Pavel Stehule
Date:
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

Re: proposal: interprocess EXPLAIN PID

From
Amit Kapila
Date:
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

Re: proposal: interprocess EXPLAIN PID

From
Pavel Stehule
Date:

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:
> 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