Re: That EXPLAIN ANALYZE patch still needs work

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: That EXPLAIN ANALYZE patch still needs work
Дата
Msg-id 20060606140343.GA9794@svana.org
обсуждение исходный текст
Ответ на That EXPLAIN ANALYZE patch still needs work  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: That EXPLAIN ANALYZE patch still needs work  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, Jun 05, 2006 at 11:02:33PM -0400, Tom Lane wrote:
> Just got this rather surprising result:

<snip bogus explain output>

> The "Total runtime" is correct AFAICT, which puts the top node's "actual
> time" rather far out in left field.  This is pretty repeatable on my old
> slow HPPA machine.  A new Xeon shows less of a discrepancy, but it's
> still claiming top node actual > total, which is not right.

Wierd. Can you get the output of *instr in each call of
InstrEndLoop? Preferably after it does the calculation but before it
clears the values. So we get an idea of number of samples and what it
guesses. SampleOverhead would be good too.

I know my version produced sensible results on my machine and the
handful of people testing, so I'll try it again with your changes, see
how it looks...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PERFORM] psql -A (unaligned format) eats too much
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Duplicate rows sneaking in despite PRIMARY KEY / UNIQUE constraint