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/
