Re: [HACKERS] Needs Suggestion

From: Tomáš Pospíšil <killteck(at)seznam(dot)cz>
To: SUBHAM ROY <subham(dot)iem(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Needs Suggestion
Date: 2011-03-27 19:01:37
Message-ID: 31953.18957.29450-16716-885908717-1301252496@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(dot)iem(at)gmail(dot)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(dot)gurjeet(at)gmail(dot)com>wrote:
>
> > On Sun, Mar 27, 2011 at 9:22 AM, SUBHAM ROY <subham(dot)iem(at)gmail(dot)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.
>
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-03-27 19:14:37 Re: Open issues for collations
Previous Message Simon Riggs 2011-03-27 17:36:20 Re: race condition in sync rep