Обсуждение: EXPLAIN stored procedures

Поиск
Список
Период
Сортировка

EXPLAIN stored procedures

От
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?


Re: EXPLAIN stored procedures

От
Andrew Gierth
Дата:
>>>>> "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)