How to see detailed plan of a funciton

From: "Obe, Regina DND\\MIS" <robe(dot)dnd(at)cityofboston(dot)gov>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: How to see detailed plan of a funciton
Date: 2005-12-05 21:30:53
Message-ID: 35F9812087218F47B050D41D1B58298B86CF37@dnd5.DND.boston.cob
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a pgsql function that returns a set of records and I'm trying to
optimize it.

Needless to say it goes thru several selects and appends to the final
result. I was wondering how I can see the query plan without having to
write things out piece meal.

Explain doesn't help too much since it doesn't get into the guts of the
selects that the function is doing.

For example my function call looks something like

select * from fnget_near_parcels('17', 'KERR PLACE', '02119')

And if I do an explain on this, I simply get

Function Scan on fnget_near_parcels (cost=0.00..12.50 rows=1000 width=287)

Thanks,
Regina

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure pursuant to
Massachusetts law. It is intended solely for the addressee. If you
received this in error, please contact the sender and delete the material
from any computer.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-12-06 00:04:13 Re: Need help building SQL query
Previous Message Frank Bax 2005-12-05 19:56:53 Re: Date Format Question