> Josh Berkus <josh@agliodbs.com> writes: > > In recent versions, we've changed the logging of function executions so > > that only the function call is logged, and not any of the queries which it > > may execute internally. While most of the time this method is superior > > for performance analysis, in applications with extensive multi-line stored > > procedures sometimes you want to log each individual query. > > ISTM that the wave of the future for this is an instrumentation plug-in, > not further kluging of the query logging functionality. I had the > impression that Korry and EDB had some prototype capability in that > direction already, and surely it shouldn't be that hard to write if not.
There's a sort of "proof-of-concept" PL/pgSQL tracer plugin in the debugger project on pgFoundry - I haven't played with it in a few months so I can't promise that it will run at the moment. If anyone is interested, let me know and I'll add this to my ToDo list. -- Korry