Cost performace question

From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: pgsql-performance(at)postgresql(dot)org
Subject: Cost performace question
Date: 2009-07-10 14:39:42
Message-ID: 308465.38702.qm@web52505.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 ((mrem_icatualizarleitura IS NULL) OR (mrem_icatualizarleitura = 2)) AND (mrem_tmleitura IS NOT NULL))

or

Aggregate (cost=26573.78..26573.79 rows=1 width=4)
-> Index Scan using xix4_movimento_roteiro_empresa on movimento_roteiro_empresa movimentor0_ (cost=0.00..26560.41 rows=5347 width=4)
Index Cond: ((ftgr_id = 26) AND (mrem_ammovimento = 200906))

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

thanks

____________________________________________________________________________________
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2009-07-10 14:51:27 Re: Cost performace question
Previous Message Albe Laurenz 2009-07-10 09:05:24 Re: embedded sql regression from 8.2.4 to 8.3.7