Postgres Pro
Downloads
Home   >   mailing lists

Re: EXPLAIN ANALYZE inside functions - Mailing list pgsql-sql

From Sabin Coanda
Subject Re: EXPLAIN ANALYZE inside functions
Date
Msg-id fhs7n9$2ok2$1@news.hub.org
Whole thread Raw
In response to EXPLAIN ANALYZE inside functions  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-sql
Tree view 
>
> 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

pgsql-sql by date:

Previous
From: "Sabin Coanda"
Date:
Subject: EXPLAIN ANALYZE inside functions
Next
From: "Luiz K. Matsumura"
Date:
Subject: Aggregate question (Sum)