Re: Measuring CPU time use? (Another stupid question)

From: Joe Conway <mail(at)joeconway(dot)com>
To: Jessica Blank <jb(at)twu(dot)net>
Cc: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Measuring CPU time use? (Another stupid question)
Date: 2002-12-18 21:03:05
Message-ID: 3E00E289.1070302@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jessica Blank wrote:
> I suppose I should rephrase.
>

[...snip...]

>
> So I guess what I'm saying is that I don't care so much about CPU time, or
> I/O time, but *TOTAL* time. How long it takes from the instant the query
> hits Postgres to the instant I get my results back...

That's pretty much exactly what EXPLAIN ANALYZE does for you. And along with
it, you get other useful information to help you improve the query.

Joe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2002-12-18 21:06:25 trouble caused by change in 7.3 handling of '' in integer context
Previous Message Jessica Blank 2002-12-18 20:56:18 Re: Measuring CPU time use? (Another stupid question)