EXPLAIN ANALYZE inside functions - Mailing list pgsql-sql

From Sabin Coanda
Subject EXPLAIN ANALYZE inside functions
Date
Msg-id fhs2cd$1aqs$1@news.hub.org
Whole thread Raw
List pgsql-sql
Hi there,

I'd like to rise the performance of a custom function, but I read somewhere 
I cannot use EXPLAIN ANALYZE to get the execution plan of the code from the 
function.

Do you know a workaround to do this ?

I tried to apply EXPLAIN ANALYZE statements inside my procedure hopping I 
will get some notice messages, but I got nothing :(.

TIA,
Sabin 




pgsql-sql by date:

Previous
From: Gregory Stark
Date:
Subject: Re: postgres bogged down beyond tolerance
Next
From: "Sabin Coanda"
Date:
Subject: Re: EXPLAIN ANALYZE inside functions