On Jun 28, 2005, at 10:54 AM, Karl O. Pinc wrote:

On 06/27/2005 06:33:03 PM, Michael Fuhr wrote:

On Mon, Jun 27, 2005 at 11:30:45PM +0000, Karl O. Pinc wrote:
> Short of that I think I'm going to be reduced to
> writing a C function that returns the real
> system time so I can spatter my code with
> RAISE statements that indicate actual execution
> time.
See timeofday().

That only gives you the time at the start of the transaction,
so you get no indication of how long anything in the
transaction takes.

I recommend you look again.

<http://www.postgresql.org/docs/8.0/interactive/functions- datetime.html#FUNCTIONS-DATETIME-CURRENT>

Michael Glaesemann
grzm myrealbox com

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to