Measuring statement runtime?

From: Andrew Edson <cheighlund(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Measuring statement runtime?
Date: 2007-02-07 17:00:32
Message-ID: 95626.55484.qm@web34201.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2007-02-07 18:41:06 Re: Measuring statement runtime?
Previous Message Joshua D. Drake 2007-02-07 16:50:14 Re: [RFC] mysql compatibility project