You could use this in psql. Don't know how precise is it, but is enought for initial testing.
postgres=# \timing
Timing is on.
postgres=# create index dx on diplomka using gist(data);
CREATE INDEX
Time: 236752.569 ms
> ------------ Původní zpráva ------------
> Od: SUBHAM ROY <subham.iem@gmail.com>
> Předmět: Re: [HACKERS] Needs Suggestion
> Datum: 27.3.2011 19:02:32
> ----------------------------------------
> Actually, I want to run some set of queries in postgres on a HUGE data set.
> I have to compute the actual execution time for each of those queries. So
> how can I do that in Postgres ?
>
> Suppose in Oracle following thing can be done :
> *
> set timing on;
> select stuff from mytab;
>
> Elapsed: 00:00:02.82
>
> *Likewise, can I do this in Postgres? "set timing on" does not work in
> Postgres.
> Also is there any free tools available in Linux for doing so?
>
> On Sun, Mar 27, 2011 at 10:20 PM, Gurjeet Singh <singh.gurjeet@gmail.com>wrote:
>
> > On Sun, Mar 27, 2011 at 9:22 AM, SUBHAM ROY <subham.iem@gmail.com> wrote:
> >
> >> Hi,
> >> I am currently a student of IIT Bombay. I am doing a project on "Benchmark
> >> design". For that I need to measure the performance of various queries in
> >> databases.
> >> I want to know how can we measure the execution time of a query in
> >> Postgres (Explain analyze will not do). Also is there any tools available in
> >> Linux for measuring the performance of queries of databases such as Oracle
> >> 11g, Postgres, etc.
> >> Any suggestions will be very helpful.
> >>
> >
> > If EXPLAIN ANALYZE is not sufficient for your purpose, then you need
> > elaborate what exactly are you looking for.
> >
> > Regards,
> > --
> > Gurjeet Singh
> > EnterpriseDB Corporation
> > The Enterprise PostgreSQL Company
> >
> >
>
>
> --
> Thank You,
> Subham Roy,
> CSE IIT Bombay.
>
>
>
