Re: Measuring execution time for sql called from PL/pgSQL - Mailing list pgsql-performance

From Tomasz Myrta
Subject Re: Measuring execution time for sql called from PL/pgSQL
Date
Msg-id 3FD9725D.9030304@klaster.net
Whole thread Raw
In response to Measuring execution time for sql called from PL/pgSQL  (Aram Kananov <aram@kananov.com>)
List pgsql-performance
Dnia 2003-12-12 02:17, Użytkownik Aram Kananov napisał:
>     select localtimestamp into v;
>     raise notice ''Timestamp: %'', v;

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




pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: fsync method checking
Next
From: David Shadovitz
Date:
Subject: Query plan - now what?