Re: Printing query durations

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Kevin Dorne <kevin(at)catalyst(dot)net(dot)nz>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Printing query durations
Date: 2006-03-28 13:32:33
Message-ID: 1143552753.3839.346.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message jao 2006-03-28 17:09:22 Array support in 8.1 JDBC driver
Previous Message Dave Cramer 2006-03-28 12:12:44 Re: Printing query durations