eighting.stocktaking_id)::text =
("ANY_subquery".stocktaking_id)::text)"
" -> Bitmap Index Scan on idx_t_weighting_stocktaking_id_user_id
(cost=0.00..212.13 rows=5796 width=0)"
"Index Cond: ((public.t_weighting.stocktaking_id)::tex
;::timestamp
without time zone) AND (stat_item_start <= '2013-09-01 00:00:00'::timestamp
without time zone))"
Is this optimization by planner possible, or it is already have been done on
newer DB version (I am using PostgreSQL 8.4.13)? IMHO it should be added into
p
Hi, here are they:
select * from t_route_type;
ID;description;type
1;"stojim";0
2;"idem";1
explain analyze
SELECT * FROM t_route
WHERE t_route.route_type_fk = 1
limit 4;
"
Hi, stright to my "problem":
explain
SELECT * FROM t_route
WHERE t_route.route_type_fk = 1
limit 4;
"Limit (cost=0.00..0.88 rows=4 width=2640)"
" -> Seq Scan on t_route (cost=0.00..118115.25 rows=538301 width=2640)"
"Filter: (route_type_fk = 1)"
If I try to select c
