| From: | Vivek Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Mauro Bertoli <bertolima(at)yahoo(dot)it> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Query history file |
| Date: | 2005-04-12 19:33:36 |
| Message-ID: | 789a8a019bd83dd8e65eca00022b34bb@khera.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-04-12 20:23:07 | Re: getting count for a specific querry |
| Previous Message | Vivek Khera | 2005-04-12 19:29:24 | Re: getting count for a specific querry |