Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7LNmcP36423 for ; Tue, 21 Aug 2001 19:48:38 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f7LNmYY13110; Tue, 21 Aug 2001 19:48:34 -0400 (EDT) To: Joseph Shraibman cc: pgsql-sql Subject: Re: exists In-reply-to: <3B82D06C.7060006@selectacast.net> References: <3B82A39A.4060307@selectacast.net> <10088.998420788@sss.pgh.pa.us> <3B82C9B4.4000200@selectacast.net> <10701.998427822@sss.pgh.pa.us> <3B82D06C.7060006@selectacast.net> Comments: In-reply-to Joseph Shraibman message dated "Tue, 21 Aug 2001 17:19:40 -0400" Date: Tue, 21 Aug 2001 19:48:34 -0400 Message-ID: <13107.998437714@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200108/284 X-Sequence-Number: 4530 Joseph Shraibman writes: > Why does explain show more than one row, even if there is a LIMIT = 1? What version are you running? I get results like regression=# explain select * from tenk1 limit 1; NOTICE: QUERY PLAN: Limit (cost=0.00..0.03 rows=1 width=148) -> Seq Scan on tenk1 (cost=0.00..333.00 rows=10000 width=148) EXPLAIN which seems at least moderately self-explanatory. regards, tom lane