Something wacko about EXPLAIN cost stats

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Something wacko about EXPLAIN cost stats
Date: 1999-01-27 20:18:47
Message-ID: 21263.917468327@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-01-27 21:27:25 Re: [HACKERS] PL/pgSQL and SPI
Previous Message Vadim Mikheev 1999-01-27 18:49:29 Re: [HACKERS] regression test HAVING fixed