Re: log_statement / log_duration / log_min_duration_statement and SPI?

On Fri, 2010-08-13 at 09:56 -0700, Maciek Sakrejda wrote:
> Hi,
>
> Is there any way to get log_min_duration_statement / log_statement /
> log_duration to work with queries issued through SPI? If this is not
> possible with a stock configuration, anyone of a patch that might be
> floating out there to add this?
>

In 8.4+ there is auto_explain, a contrib module:

http://www.postgresql.org/docs/current/static/auto-explain.html

See "auto_explain.log_nested_statements".

Regards,
    Jeff Davis