Thread: How to time several queries?

How to time several queries?

From
nd02tsk@student.hig.se
Date:
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



Re: How to time several queries?

From
"Joshua D. Drake"
Date:
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


Re: How to time several queries?

From
nd02tsk@student.hig.se
Date:
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



Re: How to time several queries?

From
"Matthew Nuzum"
Date:
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