hi ,everybody
why does the planer estimate 200 rows when i use order by and group by .
evn:postgresql 8.4 and 9.3
table:
CREATE TABLE a
(
id serial NOT NULL,
name character varying(20),
modifytime timestamp without time zone,
CONSTRAINT a_pk PRIMARY KEY (id)
)
SQL:
explain analyze
select * from
( select id from a order by id ) d
group by id;
Query plan:
"Group (cost=0.15..66.42 rows=200 width=4) (actual time=0.008..0.008 rows=0 loops=1)"
" -> Index Only Scan using a_pk on a (cost=0.15..56.30 rows=810 width=4) (actual time=0.006..0.006 rows=0 loops=1)"
" Heap Fetches: 0"
"Total runtime: 0.046 ms"
Can anybody suggest something or explain this behavior?
