Re: Increasing the length of - Mailing list pgsql-hackers

From Andrew Sullivan
Subject Re: Increasing the length of
Date
Msg-id 20041110225740.GB24990@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Increasing the length of  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: Increasing the length of  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
On Wed, Nov 10, 2004 at 05:51:01PM -0500, Andrew Sullivan wrote:
> log_statement_after_min_duration (integer) -- which did what Simon
> wants.  

Uh, well, not what Simon wants, of course, but which gave us a useful
capability anyway.  I agree that the full-bore profiling for the DBA
would be awful nice.  But in its absence, if you could see your
long-running query in the log after a minute, and then go do an
EXPLAIN and realise "uh-oh, that's gonna take 3 days to complete" and
kill it, it would be a big help.  

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.    --Alexander Hamilton


pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Increasing the length of
Next
From: Andrew Dunstan
Date:
Subject: multiline CSV fields