Something wacko about EXPLAIN cost stats

Started by Tom Laneabout 27 years ago2 messageshackers
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Tom Lane (#1)
Re: [HACKERS] 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