Re: EXPLAIN ANALYZE inside functions

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: EXPLAIN ANALYZE inside functions
Date: 2007-11-19 14:48:20
Message-ID: fhs7n9$2ok2$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Luiz K. Matsumura 2007-11-19 20:46:50 Aggregate question (Sum)
Previous Message Sabin Coanda 2007-11-19 13:17:08 EXPLAIN ANALYZE inside functions