Re: [PERFORM] How to time several queries?
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 18, 2004 2:28 PM To: [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [PERFORM] How to time several queries?
It doesn't seem to work. I want a time summary at the end. I am inserting insert queries from a file with the \i option. This is the outcome: [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.672 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.730 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.698 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.805 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.670 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.831 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.815 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.793 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.660 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.667 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.754 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.668 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.688 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.671 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.787 ms [7259] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27'); [7259] LOG: duration: 1.722 ms [7309] LOG: statement: DELETE FROM weather; [7309] LOG: duration: 11.314 ms [7330] LOG: statement: INSERT INTO weather VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27') Tim ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [PERFORM] How to time several queries?
[EMAIL PROTECTED] wrote: 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. Hello, You can turn on statement and duration logging in the postgresql.conf Thank you. Tim ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[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