Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g1DLhjE04854 for ; Wed, 13 Feb 2002 16:43:45 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g1DLh7f00852; Wed, 13 Feb 2002 16:43:07 -0500 (EST) To: Torbj=?ISO-8859-1?B?9g==?=rn Andersson cc: pgsql-sql@postgresql.org Subject: Re: How long does it take? In-reply-to: References: Comments: In-reply-to Torbj=?ISO-8859-1?B?9g==?=rn Andersson message dated "Wed, 13 Feb 2002 20:14:25 +0100" Date: Wed, 13 Feb 2002 16:43:07 -0500 Message-ID: <849.1013636587@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200202/147 X-Sequence-Number: 6574 Torbj=?ISO-8859-1?B?9g==?=rn Andersson writes: > 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... See "EXPLAIN ANALYZE" in 7.2. regards, tom lane