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