proposal: interprocess EXPLAIN PID

Started by Pavel Stehulealmost 12 years ago3 messages
#1Pavel Stehule
pavel.stehule@gmail.com

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

#2Amit Kapila
amit.kapila16@gmail.com
In reply to: Pavel Stehule (#1)
Re: proposal: interprocess EXPLAIN PID

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

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

#3Pavel Stehule
pavel.stehule@gmail.com
In reply to: Amit Kapila (#2)
Re: proposal: interprocess EXPLAIN PID

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

Show quoted text

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com