X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 52B20D1DE69 for ; Fri, 12 Dec 2003 07:47:21 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 81363-10 for ; Fri, 12 Dec 2003 03:46:51 -0400 (AST) Received: from serwer.skawsoft.com.pl (skawina.eu.org [80.48.213.66]) by svr1.postgresql.org (Postfix) with ESMTP id 8297CD1DE67 for ; Fri, 12 Dec 2003 03:46:48 -0400 (AST) Received: from klaster.net (core-1.citynet.pl [80.48.135.69]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id AF5A02B3CE; Fri, 12 Dec 2003 08:46:31 +0100 (CET) Message-ID: <3FD9725D.9030304@klaster.net> Date: Fri, 12 Dec 2003 08:46:37 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.5) Gecko/20031007 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Aram Kananov Cc: "pgsql-performance@postgresql.org" Subject: Re: Measuring execution time for sql called from PL/pgSQL References: <1071191825.5163.164.camel@localhost.localdomain> In-Reply-To: <1071191825.5163.164.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/193 X-Sequence-Number: 5053 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