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