I think I see what was happening. I was looking at the output of the
SELECT that is used for opening a cursor. Got it. Thanks for your help.
It's kind of a meta-select in the printed version of a plan if the
cursor being opened is a SELECT.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jan 19, 2005, at 3:36 AM, Michael Fuhr wrote:
> On Wed, Jan 19, 2005 at 01:46:33AM -0600, Thomas F.O'Connell wrote:
>
>> Follow-up question: are indexes used in dynamically executed queries?
>>
>> Rather than SEQSCAN or INDEXSCAN in the DETAIL item, I see RESULT
>> followed by a large amount of unreadable (by me) output.
>
> Are you sure you're looking at the right DETAIL? Adding some
> RAISE INFO or RAISE DEBUG statements can help you pinpoint which
> log output belongs to which part of the function.
>
> I just wrote a test function that used EXECUTE to do an UPDATE and
> a SELECT loop and saw INDEXSCAN in the relevant DETAIL sections.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend