Received: from itd.nrl.navy.mil (s2.itd.nrl.navy.mil [132.250.83.3]) by hub.org (8.9.3/8.9.1) with ESMTP id RAA35236 for ; Fri, 23 Apr 1999 17:27:49 -0400 (EDT) (envelope-from holston@itd.nrl.navy.mil) Received: from shell (shell [132.250.83.3]) by itd.nrl.navy.mil (8.8.8/8.8.8) with SMTP id RAA18736; Fri, 23 Apr 1999 17:27:37 -0400 (EDT) Date: Fri, 23 Apr 1999 17:27:37 -0400 (EDT) From: Gregory Holston X-Sender: holston@shell To: Bruce Momjian cc: pgsql-sql@hub.org Subject: Re: [SQL] what is "cost"? In-Reply-To: <199904232124.RAA14441@candle.pha.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Fri, 23 Apr 1999, Bruce Momjian wrote: > > > > Hi All, > > > > I just did an explain and was wondering what is meant by cost. I just > > got a 72.983 cost from a query I found not working. Any info or pointers > > would be appreciated. > > Just added to explain manual page: > > The cost value is only meaningful to the optimizer in comparing various > query plans. > I got the 72.98 on this table while doing a simple "select * from publication" meanwhile I got nothing higher than 4 on any other table. Is this indicative of a problem? -Greg