EXPLAIN
Improving query performance
jao=# create index on routing(from_member_id);
CREATE INDEX
analyze;
ANALYZE
jao=# explain select * from routing where from_member_id = 8;
QUERY PLAN
------------------------------------------------------------------------------------------
Bitmap Heap Scan on routing (cost=4.43..8.68 rows=20 width=12)
Recheck Cond: (from_member_id = 8)
-> Bitmap Index Scan on routing_from_member_id_idx (cost=0.00..4.43 rows=20 width=0)
Index Cond: (from_member_id = 8)
(4 rows)
|