Postgres Pro
Downloads
Home   >   mailing lists

Re: Trying to profile a function, but weird stuff happens - Mailing list pgsql-admin

From Tom Lane
Subject Re: Trying to profile a function, but weird stuff happens
Date
Msg-id 2666.1052938773@sss.pgh.pa.us
Whole thread Raw
In response to Trying to profile a function, but weird stuff happens  (Ericson Smith <eric@did-it.com>)
List pgsql-admin
Tree view 
Ericson Smith <eric@did-it.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

pgsql-admin by date:

Previous
From: Ericson Smith
Date:
Subject: Trying to profile a function, but weird stuff happens
Next
From: jie zhang
Date:
Subject: authentication error