How long does it take?

From: Torbj=?ISO-8859-1?B?9g==?=rn Andersson <tobbe(at)embryo(dot)se>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How long does it take?
Date: 2002-02-13 19:14:25
Message-ID: B89079A1.175D%tobbe@embryo.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(dot)andersson(at)embryo(dot)se
---------------------------------------------------
"Att idag tänka annorlunda än igår skiljer den vise från den envise." — John
Steinbeck

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jason Earl 2002-02-13 19:23:26 Re: Time Intervals
Previous Message Michael Richards 2002-02-13 16:53:33 Time Intervals