proposal: interprocess EXPLAIN PID
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
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
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