> Josh Berkus <firstname.lastname@example.org> 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