Postgres Pro
Downloads
Home   >   mailing lists

Re: That EXPLAIN ANALYZE patch still needs work - Mailing list pgsql-hackers

From Tom Lane
Subject Re: That EXPLAIN ANALYZE patch still needs work
Date
Msg-id 1590.1149801686@sss.pgh.pa.us
Whole thread Raw
In response to Re: That EXPLAIN ANALYZE patch still needs work  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: That EXPLAIN ANALYZE patch still needs work  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: That EXPLAIN ANALYZE patch still needs work  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Tried on two machines.  The first (Turion64 laptop) gives 44-45 ms for
> the SELECT, and 50-51 ms for the EXPLAIN ANALYZE.

> The second machine, desktop Celeron 533, gives 197-200 ms for the SELECT
> and 788-790 for the EXPLAIN ANALYZE.  I guess this is the reproduction
> you were looking for.

Do you have oprofile installed on these?  Comparing oprofile results
might give some more insight where the time is going.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: That EXPLAIN ANALYZE patch still needs work
Next
From: Andrew Dunstan
Date:
Subject: Re: ADD/DROP INHERITS