Re: [GENERAL] reading EXPLAIN output

2005-12-22 Thread David Rysdam
Tom Lane wrote: David Rysdam <[EMAIL PROTECTED]> writes: merge join (cost=0.00..348650.65 rows=901849 width=12) merge cond {blah} join filter {blah} index scan using {blah index on blah} (cost=0.00..289740.65 rows=11259514 width=8) index scan using {blah index on blah} (cost=0.00.

Re: [GENERAL] reading EXPLAIN output

2005-12-22 Thread Tom Lane
David Rysdam <[EMAIL PROTECTED]> writes: > merge join (cost=0.00..348650.65 rows=901849 width=12) > merge cond {blah} > join filter {blah} > index scan using {blah index on blah} (cost=0.00..289740.65 > rows=11259514 width=8) > index scan using {blah index on blah} (cost=0.00..17229.