Thread: 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
nd02tsk@student.hig.se 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 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
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
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