Re: Measuring CPU time use? (Another stupid question) - Mailing list pgsql-general

From Joe Conway
Subject Re: Measuring CPU time use? (Another stupid question)
Date
Msg-id 3E00E289.1070302@joeconway.com
Whole thread Raw
In response to Re: Measuring CPU time use? (Another stupid question)  (Jessica Blank <jb@twu.net>)
Responses Re: Measuring CPU time use? (Another stupid question)
List 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


pgsql-general by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: ORDER BY random() LIMIT 1 slowness
Next
From: Vivek Khera
Date:
Subject: trouble caused by change in 7.3 handling of '' in integer context