Re: On-demand running query plans using auto_explain and signals

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>
Cc: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: On-demand running query plans using auto_explain and signals
Date: 2015-09-14 08:44:40
Message-ID: CAFj8pRCXwoVsYMhOOJsdEwRuWfQ6a=mf39fjj7vvvW9XxMXkZg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2015-09-14 10:23 GMT+02:00 Shulgin, Oleksandr <oleksandr(dot)shulgin(at)zalando(dot)de>
:

>
>
>
> I can think of something like:
>
> EXPLAIN [ ( option [, ...] ) ] PROCESS <PID>;
>
> where option is extended with:
>
> QUERY
> PROGRESS
> BACKTRACE
>
> in addition to the usual ANALYZE, VERBOSE, FORMAT, etc.
>
>
It can work

Regards

Pavel

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2015-09-14 08:55:37 Re: RFC: replace pg_stat_activity.waiting with something more descriptive
Previous Message Kyotaro HORIGUCHI 2015-09-14 08:35:41 Re: extend pgbench expressions with functions