From: Jessica Richard <rjessil@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: time stamp and durations in postgres log file
Date: Wed, 5 Nov 2008 16:31:02 -0800 (PST)
Message-ID: <413566.82437.qm@web110411.mail.gq1.yahoo.com> (raw)
in my Postgres log file, I see something like this:
usename dbname, .., logtimestamp1... <execute> ... insert ....
then the next line:
username, dbname, ... logtimestamp2... duration: 0.2 ms
My questions:
1. Is this 0.2 ms how much time the insert takes to finish?
2. does "logtimestamp2 - logtimestamp1 " have to be equal 0.2 ms?
I am trying to create a statistics report to tell how much all database transactions take all together out of a large log file. I added up all the duration times and this number is bigger than the time span (logtimestampFrist - logtimestampLast). It does not make sense to me, probably I did something while calculating? But I would like to sure that the line with duration time is really for the transaction in the line above it.
Thanks,
Jessica
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-admin@postgresql.org
Cc: rjessil@yahoo.com
Subject: Re: time stamp and durations in postgres log file
In-Reply-To: <413566.82437.qm@web110411.mail.gq1.yahoo.com>
* 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