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 Exp

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

[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