Thread: EXPLAIN stored procedures

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?

>>>>> "Jinhua" == Jinhua Luo <luajit.io@gmail.com> 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:RhodiumToad)