Re: log_statement / log_duration / log_min_duration_statement and SPI? - Mailing list pgsql-general

From Jeff Davis
Subject Re: log_statement / log_duration / log_min_duration_statement and SPI?
Date
Msg-id 1281722558.17121.1.camel@jdavis-ux.asterdata.local
Whole thread Raw
In response to log_statement / log_duration / log_min_duration_statement and SPI?  (Maciek Sakrejda <msakrejda@truviso.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Maciek Sakrejda
Date:
Subject: log_statement / log_duration / log_min_duration_statement and SPI?
Next
From: Torsten Zühlsdorff
Date:
Subject: Re: InitDB: Bad system call