Re: logging statements in PostgreSQL

Hi,
I was looking for options to make sure SQLs executed as part of functions
also get logged. Since this is a production system, I wanted to do it
without the EXPLAIN also written to the logs. May be that is not possible?
Regards,
Jayadevan

On Mon, Sep 30, 2013 at 5:08 PM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>wrote:

> Jayadevan M wrote:
> > Thanks for the pointer. I do not really want to log the plans of
> queries, just the queries, execution
> > time and a couple of other details (database,user). If I use the
> auto-explain module, it will end up
> > printing the plan for all query execution in the log files?
>
> You can configure it so that only statements exceeding a certain
> duration will be logged.
>
> Yours,
> Laurenz Albe
>