Re: Trying to profile a function, but weird stuff happens

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ericson Smith <eric(at)did-it(dot)com>
Cc: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Trying to profile a function, but weird stuff happens
Date: 2003-05-14 18:59:33
Message-ID: 2666.1052938773@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ericson Smith <eric(at)did-it(dot)com> writes:
> I'm trying to figure out how long my function is taking to run, but it
> keeps returning identical start and stop times.

now() doesn't advance inside a transaction. See timeofday().

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message jie zhang 2003-05-14 19:35:11 authentication error
Previous Message Ericson Smith 2003-05-14 17:57:06 Trying to profile a function, but weird stuff happens