Merlin Moncure <mmoncure@xxxxxxxxx> writes: > On Tue, Jun 23, 2009 at 8:03 AM, Hartman, > Matthew<Matthew.Hartman@xxxxxxxxxx> wrote: >> 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. > What I normally do for benchmarking of complex functions is to > sprinkle the source with "raise notice '%', timeofday();" to figure > out where the bottlenecks are. Following that, I micro-optimize > problem queries or expressions outside of the function body in psql. There was some discussion once of using the same infrastructure the plpgsql debugger uses to build a plpgsql profiler. That would help automate the first part of this, at least. Anybody know the status of that project? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
