Postgres Pro
Downloads
Home   >   mailing lists

Re: EXPLAIN stored procedures - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: EXPLAIN stored procedures
Date
Msg-id 87zhwfhv54.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to EXPLAIN stored procedures  (Jinhua Luo <luajit.io@gmail.com>)
List pgsql-hackers
Tree view 
>>>>> "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)

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [PATCH] Fix for infinite signal loop in parallel scan
Next
From: Krasiyan Andreev
Date:
Subject: Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options