Re: EXPLAIN stored procedures

2018-09-18 Thread Andrew Gierth
> "Jinhua" == Jinhua Luo writes: Jinhua> Normally, EXPLAIN do not include the commands by stored Jinhua> procedures, e.g. aggregated function, trigger, correct? Jinhua> So how to review the plan by those extensions? auto_explain with its log_nested_statements option -- Andrew (irc:Rhod

EXPLAIN stored procedures

2018-09-18 Thread Jinhua Luo
Normally, EXPLAIN do not include the commands by stored procedures, e.g. aggregated function, trigger, correct? So how to review the plan by those extensions?