Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: David ShadovitzDate: 2003-12-12 08:18:12
Subject: Query plan - now what?
Previous:From: Bruce MomjianDate: 2003-12-12 06:49:26
Subject: fsync method checking

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group