Postgres Pro
Downloads
Home   >   mailing lists

Re: How long does it take? - Mailing list pgsql-sql

From Tom Lane
Subject Re: How long does it take?
Date
Msg-id 849.1013636587@sss.pgh.pa.us
Whole thread Raw
In response to How long does it take?  (Torbjörn Andersson <tobbe@embryo.se>)
List pgsql-sql
Tree view 
Torbjörn Andersson <tobbe@embryo.se> 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

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Time Intervals
Next
From: Frank Bax
Date:
Subject: Re: How long does it take?