Explaining functions.

From: "Hartman, Matthew" <Matthew(dot)Hartman(at)krcc(dot)on(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Explaining functions.
Date: 2009-06-23 12:03:21
Message-ID: 366642367C5B354197A1E0D27BC175BD02259767@KGHMAIL.KGH.ON.CA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a recommended approach when trying to use EXPLAIN on a
function? Specifically, a function that is more than the typical SELECT
statement or tiny loop. The one in question that I'm hoping to optimize
is around 250 lines.

Thanks,

Matthew Hartman
Programmer/Analyst
Information Management, ICP
Kingston General Hospital
(613) 549-6666 x4294

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message BlackMage 2009-06-23 12:15:10 Re: Inserting Values into Interval
Previous Message Jasen Betts 2009-06-23 11:55:31 Re: Replication