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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
