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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
