Re: [PERFORM] Measuring the execution time of functions within functions...

2006-04-03 Thread Jerry Sievers
Mario Splivalo <[EMAIL PROTECTED]> writes: > I have asked this before, but haven't noticed any response, so if there > were any, I appologize for asking this again... > > I have a function that is called by middle-tier (java trough JDBC), and > in postgres log I can see only the execution time of

Re: [PERFORM] Measuring the execution time of functions within functions...

2006-04-03 Thread Alvaro Herrera
Mario Splivalo wrote: > Since the function is written in plpgsql I tried to calculate the > durations by using now() function, but realized that within the > transaction now() always retunrs the same value. Maybe you can use timeofday(). -- Alvaro Herrerahttp://w