Re: EXPLAIN ANALYZE time calculations

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: EXPLAIN ANALYZE time calculations
Дата
Msg-id B7887A14-4EA8-4027-AAFB-FE44E35E4046@seespotcode.net
обсуждение исходный текст
Ответ на Re: EXPLAIN ANALYZE time calculations  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: EXPLAIN ANALYZE time calculations  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Dec 2, 2007, at 19:56 , Tom Lane wrote:

> IOW the actual time to get in and out of a node is going to be a
> shade more
> than is reported.

Thanks, Tom. Should be close enough for jazz.

When I was first going over the Using Explain section, I stumbled a
bit on the startup time/total time/loops bit (which is why explain-
analyze.info times and percentages are currently miscalculated). I
took startup time to be the time to return the first row *of the
first loop*. But it's actually the average startup time to return the
first row *in each loop*, right?

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN ANALYZE time calculations
Следующее
От: Tom Lane
Дата:
Сообщение: Re: EXPLAIN ANALYZE time calculations