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:

Re: [PERFORM] How to time several queries?

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

[PERFORM] How to time several queries?

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