From: Andrew Edson <cheighlund@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Measuring statement runtime?
Date: Wed, 7 Feb 2007 09:00:32 -0800 (PST)
Message-ID: <95626.55484.qm@web34201.mail.mud.yahoo.com> (raw)
I've got a particular sql statement I'm trying to work out that seems to be taking far too long to run. I've been told that there's supposed to be some kind of timing command to record how long a statement runs for, but I'm having trouble figuring it out. The textbook I'm working with, PostgreSQL (Second Edition) seems to be indicating a command called 'timer' but that has, so far, always thrown an error on the 't'. A search for both 'timer' and 'timing' on Postgresql.org brings up a number of results, but they all appear to have something to do with 'time' and timestamps rather than what I am attempting to find out.
What is the command I should be looking for to measure the runtime on my statements?
---------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: cheighlund@yahoo.com
Subject: Re: Measuring statement runtime?
In-Reply-To: <95626.55484.qm@web34201.mail.mud.yahoo.com>
References: <95626.55484.qm@web34201.mail.mud.yahoo.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