Re: prepared statements don't log arguments?

From: Palle Girgensohn <girgen(at)pingpong(dot)net>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: prepared statements don't log arguments?
Date: 2005-04-07 22:51:16
Message-ID: F53DEB0A2AFB9746C2886564@palle.girgensohn.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

--On torsdag, april 07, 2005 23.31.52 +0100 Simon Riggs
<simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-07 23:58:56 Re: Recognizing range constraints (was Re: Plan for relatively simple query seems to be very inefficient)
Previous Message Simon Riggs 2005-04-07 22:31:52 Re: prepared statements don't log arguments?