Re: Res: Cost performace question - Mailing list pgsql-performance

From Matthew Wakeling
Subject Re: Res: Cost performace question
Date
Msg-id alpine.DEB.2.00.0907131317510.16183@aragorn.flymine.org
Whole thread Raw
In response to Res: Cost performace question  (paulo matadr <saddoness@yahoo.com.br>)
List 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 by date:

Previous
From: paulo matadr
Date:
Subject: Res: Cost performace question
Next
From: Marc Cousin
Date:
Subject: Very big insert/join performance problem (bacula)