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.
