> 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

            -- Korry

Reply via email to