Postgres Pro
Downloads
Home   >   mailing lists

Functions and query analysis - EXPLAIN - Mailing list pgsql-novice

From Andy Halsall
Subject Functions and query analysis - EXPLAIN
Date
Msg-id BLU123-W6BE97326944EC920DF5E2F5780@phx.gbl
Whole thread Raw
Responses Re: Functions and query analysis - EXPLAIN
List pgsql-novice
Tree view
Is it possible to use EXPLAIN from inside a function? Have seen this post http://archives.postgresql.org/pgsql-general/2011-04/msg00750.php but can't get it to work on even a simple query. Need it to work on a query in a function with a UNION.
 
Perhaps there's a better way of determining if my function is using the indexes I'd like it to use?
 
Thanks,
Andy

pgsql-novice by date:

Previous
From: Bartosz Dmytrak
Date:
Subject: Re: timestamp in log table after update in another table
Next
From: Andreas Kretschmer
Date:
Subject: Re: Functions and query analysis - EXPLAIN