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

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: Aram Kananov <aram(at)kananov(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Measuring execution time for sql called from PL/pgSQL
Date: 2003-12-12 07:46:37
Message-ID: 3FD9725D.9030304@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Shadovitz 2003-12-12 08:18:12 Query plan - now what?
Previous Message Bruce Momjian 2003-12-12 06:49:26 fsync method checking