Re: log_statement / log_duration / log_min_duration_statement and SPI?

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Maciek Sakrejda <msakrejda(at)truviso(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: log_statement / log_duration / log_min_duration_statement and SPI?
Date: 2010-08-13 18:02:38
Message-ID: 1281722558.17121.1.camel@jdavis-ux.asterdata.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Zühlsdorff 2010-08-13 18:58:49 Re: InitDB: Bad system call
Previous Message Maciek Sakrejda 2010-08-13 16:56:09 log_statement / log_duration / log_min_duration_statement and SPI?