Skip site navigation (1) Skip section navigation (2)

Re: current_timestamp after queries

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Guido Staub <staub(at)gik(dot)uni-karlsruhe(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: current_timestamp after queries
Date: 2002-09-30 15:02:17
Message-ID: 200209301502.g8UF2IF14332@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
CURRENT_TIMESTAMP returns the time of the transaction start, not the
statement start.  We are currently discussing on hackers whether this is
correct or not.  We don't currently allow you to access the statement
start time.  Sorry.

---------------------------------------------------------------------------

Guido Staub wrote:
> Hi all,
> I'm trying the following:
> BEGIN;
> select current_timestamp into mytable;
> .
> some queries
> .
> insert current timestamp into mytable;
> COMMIT;
> When I call this with the \i <filename> command, all is working fine,
> but the two current_timestamp entries are the same, there is no
> difference between them but there should. So I've tried:
> BEGIN;
> select current_timestamp into mytable;
> .
> some queries
> .
> COMMIT;
> BEGIN;
> insert current_timestamp into mytable;
> COMMIT;
> and now the entries are different.
> I think that the accuracy is not good enough because I've started two
> BEGIN statements and some time is elapsing between them. Am I right?
> Or does anybody know a better solution to store the elapsed time after
> some queries without writing some code in C or JAVA?
> 
> Thanks in advance
> Guido Staub

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-09-30 15:02:55
Subject: Re: current_timestamp after queries
Previous:From: Bruce MomjianDate: 2002-09-30 14:48:43
Subject: Re: Do we want a CVS branch now?

pgsql-general by date

Next:From: Bruce MomjianDate: 2002-09-30 15:02:55
Subject: Re: current_timestamp after queries
Previous:From: Tom LaneDate: 2002-09-30 14:57:00
Subject: Re: Beta2 - A Late Announcement

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group