SUBHAM ROY <[email protected]> writes: > 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.
Try pgbench (in contribs) and then Tsung, that could help you run a test suite and get time reports. See also pgbench-tools. http://www.westnet.com/~gsmith/content/postgresql/pgbench-tools.htm Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
