Re: Allow auto_explain to log plans before queries are executed

Kyotaro Horiguchi-4 wrote
> At Thu, 27 Feb 2020 06:27:24 +0100, Pavel Stehule <

> pavel.stehule@

> > wrote in
>> odesílatel Kyotaro Horiguchi <

> horikyota.ntt@

> >
>> napsal:
>
> If we need a live plan dump of a running query, We could do that using
> some kind of inter-backend triggering. (I'm not sure if PG offers
> inter-backend signalling facility usable by extensions..)
>
> =# select auto_explain.log_plan_backend(12345);
>
> postgresql.log:
> LOG: requested plan dump: <blah, blah>..
>
> regards.
>
> --
> Kyotaro Horiguchi
> NTT Open Source Software Center

Did you know
https://www.postgresql-archive.org/pg-show-plans-Seeing-all-execution-plans-at-once-td6129231.html
?

Regards
PAscal

--
Sent from: https://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html