Re: [GENERAL] explain, planner and more..

2001-08-14 Thread Tom Lane
Svenne Krap <[EMAIL PROTECTED]> writes: > Why does the planner choose not to use numberdomain_pkey as index on > numberdomain ? > -> Seq Scan on numberdomain nd (cost=0.00..1.85 > rows=1 width=31) Evidently because it thinks numberdomain only has one disk block, and hence the

[GENERAL] explain, planner and more..

2001-08-14 Thread Svenne Krap
Hi, how has the following to be read.. (ie. what is the total cost of the query)... 4.05, 5.88 or ? Why does the planner choose not to use numberdomain_pkey as index on numberdomain ? The table layout is quite bad (due to a lot of last minute-changes) # explain select c.*, (select count(*) f