The statement timing was showing "seconds.milliseconds ms" instead of
"milliseconds.milliseconds ms". Attached patch should fix it up.

--
Greg Sabino Mullane [EMAIL PROTECTED]  [EMAIL PROTECTED]
End Point Corporation
PGP Key: 0x14964AC8 200608091553
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8


Index: postgres.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/tcop/postgres.c,v
retrieving revision 1.496
diff -u -c -r1.496 postgres.c
*** postgres.c	8 Aug 2006 01:23:15 -0000	1.496
--- postgres.c	9 Aug 2006 19:50:35 -0000
***************
*** 1094,1104 ****
  			if (was_logged)
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms",
! 								secs, msecs)));
  			else
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms  statement: %s%s",
! 								secs, msecs,
  								query_string,
  								prepare_string ? prepare_string : "")));
  		}
--- 1094,1104 ----
  			if (was_logged)
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms",
! 								secs * 1000 + msecs, usecs % 1000)));
  			else
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms  statement: %s%s",
! 								secs * 1000 + msecs, usecs % 1000,
  								query_string,
  								prepare_string ? prepare_string : "")));
  		}
***************
*** 1855,1865 ****
  			if (log_statement == LOGSTMT_ALL)	/* already logged? */
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms",
! 								secs, msecs)));
  			else
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms  execute %s%s%s%s:  %s",
! 								secs, msecs,
  								execute_is_fetch ? "fetch from " : "",
  								portal->prepStmtName ? portal->prepStmtName : "<unnamed>",
  								*portal->name ? "/" : "",
--- 1855,1865 ----
  			if (log_statement == LOGSTMT_ALL)	/* already logged? */
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms",
! 								secs * 1000 + msecs, usecs % 1000)));
  			else
  				ereport(LOG,
  						(errmsg("duration: %ld.%03d ms  execute %s%s%s%s:  %s",
! 								secs * 1000 + msecs, usecs % 1000,
  								execute_is_fetch ? "fetch from " : "",
  								portal->prepStmtName ? portal->prepStmtName : "<unnamed>",
  								*portal->name ? "/" : "",

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to