Re: Res: [PERFORM] Cost performace question

2009-07-13 Thread Matthew Wakeling
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 rec

Res: [PERFORM] Cost performace question

2009-07-10 Thread paulo matadr
mance@postgresql.org; paulo matadr Enviadas: Sexta-feira, 10 de Julho de 2009 11:51:27 Assunto: Re: [PERFORM] Cost performace question paulo matadr 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, t

Re: [PERFORM] Cost performace question

2009-07-10 Thread Kevin Grittner
paulo matadr 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 cos

[PERFORM] Cost performace question

2009-07-10 Thread paulo matadr
Hi all have a dought about explain of postgres Let's see: Who have more cost for database: Index Scan using xix3_movimento_roteiro_empresa on movimento_roteiro_empresa movimentor0_ (cost=0.00..73386.80 rows=5126 width=451) Index Cond: (mrem_ammovimento = 200906) Filter: ((ftgr_id = 26) AND (