Re: Logging functions executed by queries in 8.2?

> Josh Berkus <josh(at)agliodbs(dot)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