Re: Needs Suggestion

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.