Current CVS sources are giving silly values for the cost fields of
EXPLAIN output:

treetest=> explain select * from marketorderhistory order by ordertime;
NOTICE:  QUERY PLAN:

Sort  (cost=??????? size=1610612736 width=1081364283)
  ->  Seq Scan on marketorderhistory  (cost=??????? size=1610612736 width=108136
4283)

EXPLAIN
treetest=> explain select * from marketorderhistory where ordertime = 'now';
NOTICE:  QUERY PLAN:

Index Scan using marketorderhistory_ordertime_in on marketorderhistory  (cost=??
????? size=-536870912 width=1074351372)

EXPLAIN

Looks the same before and after VACUUM, btw.

			regards, tom lane

Wed, 27 Jan 1999 15:18:47 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Something wacko about EXPLAIN cost stats
Can't reproduce it here.

> Current CVS sources are giving silly values for the cost fields of
> EXPLAIN output:
> 
> treetest=> explain select * from marketorderhistory order by ordertime;
> NOTICE:  QUERY PLAN:
> 
> Sort  (cost=??????? size=1610612736 width=1081364283)
>   ->  Seq Scan on marketorderhistory  (cost=??????? size=1610612736 width=108136
> 4283)
> 
> EXPLAIN
> treetest=> explain select * from marketorderhistory where ordertime = 'now';
> NOTICE:  QUERY PLAN:
> 
> Index Scan using marketorderhistory_ordertime_in on marketorderhistory  (cost=??
> ????? size=-536870912 width=1074351372)
> 
> EXPLAIN
> 
> Looks the same before and after VACUUM, btw.
> 
> 			regards, tom lane
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 2 Feb 1999 14:06:55 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Something wacko about EXPLAIN cost stats