| From: | nd02tsk(at)student(dot)hig(dot)se |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: How to time several queries? |
| Date: | 2004-10-20 11:50:38 |
| Message-ID: | 3879.130.243.12.121.1098273038.squirrel@130.243.12.121 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Nuzum | 2004-10-20 12:50:42 | Re: How to time several queries? |
| Previous Message | Aaron Werman | 2004-10-20 11:10:35 | Re: Free PostgreSQL Training, Philadelphia, Oct 30 |