Hackers,
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.
While it's kind of possible to do this via RAISE NOTICE, that doesn't
accurately get you execution times, let alone allow you do to thinks like
log query plans. This is seriously hampering our ability to
performance-optimize for TPCE.
Questions:
1) Is there any workaround for 8.2 which would allow us to log the function
queries and plans?
2) Would it be reasonable to add a log_function_bodies option for 8.3?
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco