Re: Query history file

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: Query history file
Дата
Msg-id 789a8a019bd83dd8e65eca00022b34bb@khera.org
обсуждение исходный текст
Ответ на Re: Query history file  (Mauro Bertoli <bertolima@yahoo.it>)
Список 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 по дате отправления:

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: getting count for a specific querry
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: getting count for a specific querry