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

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

[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