Res: Cost performace question - Mailing list pgsql-performance

From paulo matadr
Subject Res: Cost performace question
Date
Msg-id 326710.81152.qm@web52503.mail.re2.yahoo.com
Whole thread Raw
In response to Re: Cost performace question  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Res: Cost performace question  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance
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?




De: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Para: pgsql-performance@postgresql.org; paulo matadr <saddoness@yahoo.com.br>
Enviadas: Sexta-feira, 10 de Julho de 2009 11:51:27
Assunto: Re: [PERFORM] Cost performace question

paulo matadr <saddoness@yahoo.com.br> wrote:

> Im confused about who is the most import (colour red ou blue).

For the benefit of those without an easy way to view email in http,
the first cost number was in red, the second in blue.

The first number is the cost to retrieve the first row, the second
number is the cost to retrieve the full set of rows.  Usually I'm
paying more attention to the second number.

-Kevin

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


Veja quais são os assuntos do momento no Yahoo! + Buscados: Top 10 - Celebridades - Música - Esportes

pgsql-performance by date:

Previous
From: Brian Cox
Date:
Subject: Re: autovacuum hung?
Next
From: Matthew Wakeling
Date:
Subject: Re: Res: Cost performace question