Re: [HACKERS] proposal: interprocess EXPLAIN PID

2014-04-13 Thread Pavel Stehule 
Hello

2014-04-13 7:16 GMT+02:00 Amit Kapila :

> On Fri, Apr 11, 2014 at 12:13 PM, Pavel Stehule 
> 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
>

Re: [HACKERS] proposal: interprocess EXPLAIN PID

2014-04-12 Thread Amit Kapila 
On Fri, Apr 11, 2014 at 12:13 PM, Pavel Stehule  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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] proposal: interprocess EXPLAIN PID

2014-04-10 Thread Pavel Stehule 
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