From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Something wacko about EXPLAIN cost stats |
Date: | 1999-02-02 19:06:55 |
Message-ID: | 199902021906.OAA06696@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-02-02 19:19:13 | Re: [HACKERS] Adding some const keywords to external interfaces |
Previous Message | D'Arcy J.M. Cain | 1999-02-02 18:58:28 | Re: [HACKERS] Adding some const keywords to external interfaces |