Re: [PERFORM] Measuring execution time for sql called from PL/pgSQL

[Tomasz Myrta]

Dnia 2003-12-12 02:17, Użytkownik Aram Kananov napisał:
    select localtimestamp into v;
    raise notice ''Timestamp: %'', v;


Advertising






Don't use localtimestamp, now() neither any transaction based time 
function. They all return the same value among whole transaction. The 
only time function, which can be used for performance tests is timeofday().

You can read more about time functions in manual.

Regards,
Tomasz Myrta


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster