Joseph Shraibman <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
