Re: Triggers / Procedures

On Aug 24, 2004, at 9:21 PM, Steve Tucknott wrote:

>  PostGreSql 7.4.3
>
>  I have a function that 'audits' inserts / updates on other tables - I
> have put timetraps in the code to see why it takes so long. The
> problem is that the timetrap shows a common time although the lapse in
> the display of the time is 5 to 6 seconds. How can I see what is
> actually going on?

<snip />

>         SELECT CURRENT_TIMESTAMP INTO l_timeStamp;
>            RAISE NOTICE '(%) INserted (%)
> (%)',l_timeStamp,TG_ARGV[1],TG_ARGV[0]; 

current_timestamp is evaluated once for the transaction. To see "wall
clock" time, use timeofday() (which, FYI, returns a text string rather
than a timestamp value). For more information,
<http://www.postgresql.org/docs/current/static/functions-datetime.html>

Michael Glaesemann
grzm myrealbox com