Re: prepared statements don't log arguments?

Поиск
Список
Период
Сортировка
От Palle Girgensohn
Тема Re: prepared statements don't log arguments?
Дата
Msg-id F53DEB0A2AFB9746C2886564@palle.girgensohn.se
обсуждение исходный текст
Ответ на Re: prepared statements don't log arguments?  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: prepared statements don't log arguments?
Список pgsql-hackers
--On torsdag, april 07, 2005 23.31.52 +0100 Simon Riggs 
<simon@2ndquadrant.com> wrote:

> On Wed, 2005-04-06 at 15:01 +0200, Palle Girgensohn wrote:
>> I really need to know the *real* arguments...
>
> Why do you need to log the arguments as well?

Debugging purposes. If I fealize there are queries hogging the server, I'd 
like to get them from a log so I can tune the system, maybe add an index or 
find the qurey in the src code an rephrase it. It is *very* helpful to a 
proper set of arguments for a slow query, since another set of arguments 
will probably give a very speedy result. I need to find the hogs, basically.

/Palle





В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: prepared statements don't log arguments?
Следующее
От: Bernd Helmle
Дата:
Сообщение: Re: Call for objections: merge Resdom with TargetEntry