From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ryszard Lach <siaco@autograf.pl>
Cc: pgsql-performance@postgresql.org, Bruce Momjian <pgman@candle.pha.pa.us>
Subject: Re: duration logging setting in 7.4
Date: Thu, 20 Nov 2003 19:17:01 -0500
Message-ID: <7948.1069373821@sss.pgh.pa.us> (raw)
In-Reply-To: <20031118091646.GA8223@siaco.id.pl>
References: <20031117222058.GD3248@siaco.id.pl>
<200311180237.hAI2b7s29417@candle.pha.pa.us>
<20031118091646.GA8223@siaco.id.pl>
Ryszard Lach <siaco@autograf.pl> writes:
> Nov 18 10:05:20 postgres[1348]: [318-1] LOG: duration: 0.297 ms statement:
> Nov 18 10:05:20 postgres[1311]: [5477-1] LOG: duration: 0.617 ms statement:
> Nov 18 10:05:20 postgres[1312]: [5134-1] LOG: duration: 0.477 ms statement:
> Nov 18 10:05:20 postgres[1349]: [318-1] LOG: duration: 0.215 ms statement:
> Nov 18 10:05:20 postgres[1313]: [5449-1] LOG: duration: 0.512 ms statement:
> Nov 18 10:05:20 postgres[1314]: [5534-1] LOG: duration: 0.420 ms statement:
> Nov 18 10:05:20 postgres[1330]: [772-1] LOG: duration: 1.386 ms statement: SELECT * FROM mytablemius WHERE id = 0;
> Nov 18 10:05:20 postgres[1315]: [5757-1] LOG: duration: 0.417 ms statement:
> Nov 18 10:05:20 postgres[1316]: [5885-1] LOG: duration: 0.315 ms statement:
> Nov 18 10:05:20 postgres[1317]: [5914-1] LOG: duration: 0.301 ms statement:
> Nov 18 10:05:20 postgres[1318]: [5990-1] LOG: duration: 0.293 ms statement:
> Nov 18 10:05:20 postgres[1319]: [6009-1] LOG: duration: 0.211 ms statement:
> Nov 18 10:05:20 postgres[1320]: [6039-1] LOG: duration: 0.188 ms statement:
Is it possible that you're sending a lot of queries that have an initial
newline in the text? I'd expect the first line of log output for such a
query to look as above.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, siaco@autograf.pl, pgman@candle.pha.pa.us
Subject: Re: duration logging setting in 7.4
In-Reply-To: <7948.1069373821@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox