Re: Printing query durations - Mailing list pgsql-jdbc

From Simon Riggs
Subject Re: Printing query durations
Date
Msg-id 1143552753.3839.346.camel@localhost.localdomain
Whole thread Raw
In response to Re: Printing query durations  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
On Tue, 2006-03-28 at 07:12 -0500, Dave Cramer wrote:

> What happens if I turn log_duration on ? Doesn't it prepend the
> duration to every log ?

No.

If you use log_statement the statement is logged before execution,
whereas the duration is known only at the end, so two log records are
produced.

log_min_duration_statement logs both at the end so is better suited to
performance analysis.

Best Regards, Simon Riggs



pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Printing query durations
Next
From: jao@geophile.com
Date:
Subject: Array support in 8.1 JDBC driver