Re: Res: Cost performace question

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