Received: from multivac.embryo.se (multivac.embryo.se [195.149.181.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1DJESE57511 for ; Wed, 13 Feb 2002 14:14:28 -0500 (EST) (envelope-from tobbe@embryo.se) Received: from tuba.embryo.se ([172.16.0.67]) by multivac.embryo.se with esmtp (Exim 3.12 #1 (Debian)) id 16b4rL-00086A-00 for ; Wed, 13 Feb 2002 20:14:27 +0100 User-Agent: Microsoft-Entourage/10.0.0.1309 Date: Wed, 13 Feb 2002 20:14:25 +0100 Subject: How long does it take? From: Torbj=?ISO-8859-1?B?9g==?=rn Andersson To: Message-ID: In-Reply-To: <20020213182241.GB10858@rice.edu> Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by postgresql.org id g1DJLJF58048 X-Archive-Number: 200202/142 X-Sequence-Number: 6570 Does anyone have any good tips on how to measure the time it takes to extecute an SQL-statement in psql? I'd like to use it in conjunction with EXPLAIN in order to help me determine what needs to be optimized as well as checking that my optimization actually improved matters... Best regards Torbjörn Andersson --------------------------------------------------- Embryo Communication phone: +46 (0) 31-774 39 11(00) Kungsgatan 7a fax: +46 (0)31 774 07 80 S-411 19 Göteborg mobile: 0708-30 70 04 Sweden home: http://www.embryo.se/ mail: torbjorn.andersson@embryo.se --------------------------------------------------- "Att idag tänka annorlunda än igår skiljer den vise från den envise." — John Steinbeck