Re: exists

I'm running 7.1.3.  What does 'rows=10000' mean?   The number of rows returned or the 
number postgres has to look through?

Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.net> 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
> 


-- 
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com