Thread: Something wacko about EXPLAIN cost stats

Something wacko about EXPLAIN cost stats

From
Tom Lane
Date:
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


Re: [HACKERS] Something wacko about EXPLAIN cost stats

From
Bruce Momjian
Date:
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,
Pennsylvania19026