Re: How to EXPLAIN a trigger function

Dne Po 17. srpna 2015 13:25:25, Albe Laurenz napsal(a):
> Zdenek Belehrádek wrote:
>
> > We
> > would like to know if there is simple way to EXPLAIN the trigger function,
> > so we could optimize it.
>
>
> I believe that the auto_explain module could help you:
> http://www.postgresql.org/docs/current/static/auto-explain.html
>
> If you turn on "auto_explain.log_nested_statements" and set
> "auto_explain.log_min_duration" low enough, the execution plans of
> all SQL statements calle from a function will be logged.
>
> Yours,
> Laurenz Albe

Oh, sorry, I am an idiot. I totally missed the
auto_explain.log_nested_statements. With it set to true, I am getting the
trigger's EXPLAIN too.

Thank you very much!

--Zdeněk Bělehrádek.