Re: [PERFORM] How to time several queries?

2004-10-20 Thread Matthew Nuzum 
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?

2004-10-20 Thread nd02tsk 
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?

2004-10-18 Thread Joshua D. Drake 
[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