Received: from tomts23-srv.bellnexxia.net (tomts23.bellnexxia.net [209.226.175.185]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1E2FQE63746 for ; Wed, 13 Feb 2002 21:15:26 -0500 (EST) (envelope-from fbax@sympatico.ca) Received: from ACER ([65.94.214.129]) by tomts23-srv.bellnexxia.net (InterMail vM.4.01.03.23 201-229-121-123-20010418) with SMTP id <20020214021330.IKJ16071.tomts23-srv.bellnexxia.net@ACER>; Wed, 13 Feb 2002 21:13:30 -0500 Message-Id: <3.0.6.32.20020213211245.007d65b0@pop6.sympatico.ca> X-Sender: b1wudu74@pop6.sympatico.ca X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.6 (32) Date: Wed, 13 Feb 2002 21:12:45 -0500 To: =?iso-8859-1?Q?Torbj=F6g?= ==rn Andersson From: Frank Bax Subject: Re: How long does it take? Cc: In-Reply-To: References: <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 g1E2LmF64174 X-Archive-Number: 200202/149 X-Sequence-Number: 6576 time psql -c "select now()" now ------------------------ 2002-02-13 21:21:17-05 (1 row) 0.09s real 0.05s user 0.01s system At 08:14 PM 2/13/02 +0100, Torbjög==rn Andersson wrote: >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 > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >