pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

EXPLAIN ANALYZE inside functions
2+ messages / 1 participants
[nested] [flat]

* EXPLAIN ANALYZE inside functions
@ 2007-11-19 13:17 Sabin Coanda <sabin.coanda@deuromedia.ro>
  2007-11-19 14:48 ` Re: EXPLAIN ANALYZE inside functions Sabin Coanda <sabin.coanda@deuromedia.ro>
  0 siblings, 1 reply; 2+ messages in thread

From: Sabin Coanda @ 2007-11-19 13:17 UTC (permalink / raw)
  To: 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 





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: EXPLAIN ANALYZE inside functions
  2007-11-19 13:17 EXPLAIN ANALYZE inside functions Sabin Coanda <sabin.coanda@deuromedia.ro>
@ 2007-11-19 14:48 ` Sabin Coanda <sabin.coanda@deuromedia.ro>
  0 siblings, 0 replies; 2+ messages in thread

From: Sabin Coanda @ 2007-11-19 14:48 UTC (permalink / raw)
  To: pgsql-sql

>
> Do you know a workaround to do this ?
>

I just succeeded adding the following code:

FOR rec IN EXECUTE 'EXPLAIN ANALYZE ' || sSQL LOOP
        RAISE NOTICE ' - %', rec;
END LOOP;

Regards,
Sabin 





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2007-11-19 14:48 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-11-19 13:17 EXPLAIN ANALYZE inside functions Sabin Coanda <sabin.coanda@deuromedia.ro>
2007-11-19 14:48 ` Sabin Coanda <sabin.coanda@deuromedia.ro>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox