Received: from candle.pha.pa.us (maillist@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.2/8.9.1) with ESMTP id SAA99134 for ; Wed, 3 Feb 1999 18:10:52 -0500 (EST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id SAA27570; Wed, 3 Feb 1999 18:11:00 -0500 (EST) From: Bruce Momjian Message-Id: <199902032311.SAA27570@candle.pha.pa.us> Subject: Re: [GENERAL] EXPLAIN In-Reply-To: from Andy at "Feb 3, 1999 5: 0:59 pm" To: alewis@mpsi.net (Andy) Date: Wed, 3 Feb 1999 18:11:00 -0500 (EST) Cc: pgsql-general@postgreSQL.org X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit > When I do an explain what does the cost, size and width mean that is returned? > > Seq Scan on apts (cost=249.95 size=2362 width=468) Cost is a computed value by the optimizer of how long it will execute. It is meaningful only in comparison to there queries. size if the number of rows estimated to return. width is the number of bytes per row returned. -- 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