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



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match