debugging plpgsql functions

Hi all,

I have a few plpgsql functions to debug to see why they are slow.

They consist of a bunch of sql statements using new.* / old.* variables
(ie not using "EXECUTE", the sql is being called directly).

Is there a way to capture the actual sql that's being executed with
variables substituted in, or even an easy way to log the variables being
used?

I couldn't see anything in the manual but maybe I missed something - any
pointers appreciated.

I tried http://pgfoundry.org/projects/edb-debugger/ but after loading
the module, the functions wouldn't run properly (can't remember the
error message but I can do it again if need be).

--
Postgresql & php tutorials
http://www.designmagick.com/