Skip site navigation (1) Skip section navigation (2)

Re: How to time several queries?

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 (view raw or flat)
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



pgsql-performance by date

Next:From: Matthew NuzumDate: 2004-10-20 12:50:42
Subject: Re: How to time several queries?
Previous:From: Aaron WermanDate: 2004-10-20 11:10:35
Subject: Re: Free PostgreSQL Training, Philadelphia, Oct 30

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group