Re: Query history file - Mailing list pgsql-sql

From Vivek Khera
Subject Re: Query history file
Date
Msg-id 789a8a019bd83dd8e65eca00022b34bb@khera.org
Whole thread Raw
In response to Re: Query history file  (Mauro Bertoli <bertolima@yahoo.it>)
List pgsql-sql
On Apr 5, 2005, at 11:29 AM, Mauro Bertoli wrote:

>> From the
>> server side, if you enable 'log_statement' all
>> queries will go into the
>> server logs.
> Thank you, I enabled
> log_statement = all
> log_duration = true

You may also want

log_min_error_statement = error

else any statement that causes an error (such as a typo) will not be 
logged -- just the error gets logged.  Makes debugging of very complex 
systems much easier to be able to see the full query that caused the 
problem.

Vivek Khera, Ph.D.
+1-301-869-4449 x806


pgsql-sql by date:

Previous
From: Vivek Khera
Date:
Subject: Re: getting count for a specific querry
Next
From: Scott Marlowe
Date:
Subject: Re: getting count for a specific querry