Re: prepared statements don't log arguments? - Mailing list pgsql-hackers

From Palle Girgensohn
Subject Re: prepared statements don't log arguments?
Date
Msg-id F53DEB0A2AFB9746C2886564@palle.girgensohn.se
Whole thread Raw
In response to Re: prepared statements don't log arguments?  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: prepared statements don't log arguments?
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: prepared statements don't log arguments?
Next
From: Bernd Helmle
Date:
Subject: Re: Call for objections: merge Resdom with TargetEntry