Re: Res: Cost performace question

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: Res: Cost performace question
Дата
Msg-id alpine.DEB.2.00.0907131317510.16183@aragorn.flymine.org
обсуждение исходный текст
Ответ на Res: Cost performace question  (paulo matadr <saddoness@yahoo.com.br>)
Список pgsql-performance
On Fri, 10 Jul 2009, paulo matadr wrote:
> thanks i understand now,  i have other dought
> Index Scan using xix3_movimento_roteiro_empresa on movimento_roteiro_empresa movimentor0_  (cost=0.00..73386.80
> rows=5126 width=451)
> what's this mean on red color above?

Please don't assume that everyone receiving your mails uses a HTML mail
reader. In fact, recommended netiquette is to not send HTML mails at all.
Many people set their email programs to automatically reject (as spam) any
emails containing HTML.

Manually reading the HTML, it seems that you are referring to the
"width=451" part of the EXPLAIN result. Please read the manual at
http://www.postgresql.org/docs/8.4/interactive/using-explain.html

The width is the:

* Estimated average width (in bytes) of rows output by this plan node

Matthew

--
 There once was a limerick .sig
 that really was not very big
 It was going quite fine
 Till it reached the fourth line

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

Предыдущее
От: paulo matadr
Дата:
Сообщение: Res: Cost performace question
Следующее
От: Marc Cousin
Дата:
Сообщение: Very big insert/join performance problem (bacula)