Re: gettime() - a timeofday() alternative - Mailing list pgsql-hackers

From mark@mark.mielke.cc
Subject Re: gettime() - a timeofday() alternative
Date
Msg-id 20050813213538.GA30952@mark.mielke.cc
Whole thread Raw
In response to Re: gettime() - a timeofday() alternative  (Brendan Jurd <direvus@gmail.com>)
List pgsql-hackers
On Sun, Aug 14, 2005 at 05:51:16AM +1000, Brendan Jurd wrote:
> Regarding the statement_timestamp() ... if the entire query path is
> parser -> rewriter -> planner/optimiser -> executor, what point in
> that path would be considered the true start of the "statement"?  I
> would assume that it's right at the beginning, when it is first handed
> to the parser, but that's a very naive assumption.

The latest time before any index or table has been accessed to derive
results?

For prepared statements, for example, the time the statement was prepared
doesn't seem useful to me.

Cheers,
mark

-- 
mark@mielke.cc / markm@ncf.ca / markm@nortel.com     __________________________
.  .  _  ._  . .   .__    .  . ._. .__ .   . . .__  | Neighbourhood Coder
|\/| |_| |_| |/    |_     |\/|  |  |_  |   |/  |_   | 
|  | | | | \ | \   |__ .  |  | .|. |__ |__ | \ |__  | Ottawa, Ontario, Canada
 One ring to rule them all, one ring to find them, one ring to bring them all                      and in the darkness
bindthem...
 
                          http://mark.mielke.cc/



pgsql-hackers by date:

Previous
From: Brendan Jurd
Date:
Subject: Re: gettime() - a timeofday() alternative
Next
From: Tom Lane
Date:
Subject: Re: gettime() - a timeofday() alternative