pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matthew Nuzum <newz@bearfruit.org>
To: nd02tsk@student.hig.se
To: pgsql-performance@postgresql.org
Subject: Re: How to time several queries?
Date: Wed, 20 Oct 2004 08:50:42 -0400
Message-ID: <200410201250.i9KConZn016806@ms-smtp-02.tampabay.rr.com> (raw)
In-Reply-To: <2612.130.243.12.107.1098124104.squirrel@130.243.12.107>

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




view thread (4+ messages)

Message-ID: <200410201250.i9KConZn016806@ms-smtp-02.tampabay.rr.com>
Permalink:  ../200410201250.i9KConZn016806@ms-smtp-02.tampabay.rr.com/
Also on:    postgresql.org/message-id/200410201250.i9KConZn016806@ms-smtp-02.tampabay.rr.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: newz@bearfruit.org, nd02tsk@student.hig.se
  Subject: Re: How to time several queries?
  In-Reply-To: <200410201250.i9KConZn016806@ms-smtp-02.tampabay.rr.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox