Re: logging statements in PostgreSQL - Mailing list pgsql-general

From Albe Laurenz
Subject Re: logging statements in PostgreSQL
Date
Msg-id A737B7A37273E048B164557ADEF4A58B17C2505E@ntex2010a.host.magwien.gv.at
Whole thread Raw
In response to Re: logging statements in PostgreSQL  (Jayadevan M <maymala.jayadevan@gmail.com>)
Responses Re: logging statements in PostgreSQL  (Jayadevan M <maymala.jayadevan@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Quotes, double quotes...
Next
From: Moshe Jacobson
Date:
Subject: Re: psql swallowed my "BEGIN;" on reset... user beware?