When I'm using psql and I want to time queries, which is what I've been
doing for a little over a day now, I do the following:
Select now(); query 1; query 2; query 3; select now();
This works fine unless you're doing selects with a lot of rows which will
cause your first timestamp to scroll off the screen.
--
Matthew Nuzum + "Man was born free, and everywhere
www.bearfruit.org : he is in chains," Rousseau
+~~~~~~~~~~~~~~~~~~+ "Then you will know the truth, and
the TRUTH will set you free," Jesus Christ (John 8:32 NIV)
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org] On Behalf Of
nd02tsk@student.hig.se
Sent: Monday, October 18, 2004 2:28 PM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] How to time several queries?
Hello
I posted this on the general list but think it would be more appropriate
here. Sorry.
I know it is possible to time isolated queries through the settting of the
\timing option in psql. This makes PgSQL report the time it took to
perform one operation.
I would like to know how one can get a time summary of many operations, if
it is at all possible.
Thank you.
Tim
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster