Re: [HACKERS] proposal: interprocess EXPLAIN PID

2014-04-13 Thread Pavel Stehule 
Hello

2014-04-13 7:16 GMT+02:00 Amit Kapila amit.kapil...@gmail.com:

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

Re: [HACKERS] proposal: interprocess EXPLAIN PID

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


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