EXPLAIN stored procedures

Started by Jinhua Luoover 7 years ago2 messages
#1Jinhua Luo
luajit.io@gmail.com

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?

#2Andrew Gierth
andrew@tao11.riddles.org.uk
In reply to: Jinhua Luo (#1)
Re: EXPLAIN stored procedures

"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)