Skip site navigation (1) Skip section navigation (2)

Functions and query analysis - EXPLAIN

From: Andy Halsall <halsall_andy(at)hotmail(dot)com>
To: "postgresql (dot)org novice list" <pgsql-novice(at)postgresql(dot)org>
Subject: Functions and query analysis - EXPLAIN
Date: 2012-02-10 17:07:21
Message-ID: BLU123-W6BE97326944EC920DF5E2F5780@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Is it possible to use EXPLAIN from inside a function? Have seen this post 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?


pgsql-novice by date

Next:From: Andreas KretschmerDate: 2012-02-10 17:54:31
Subject: Re: Functions and query analysis - EXPLAIN
Previous:From: Bartosz DmytrakDate: 2012-02-10 15:07:03
Subject: Re: timestamp in log table after update in another table

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group