begin;
explain analyze select * from mm_insrel_table where dnumber=558332 and dir<>1;
rollback;
                                                                QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on mm_insrel_table  (cost=2.11..113.50 rows=30 width=20) (actual time=0.089..0.096 rows=2 loops=1)
   Recheck Cond: ((dnumber = 558332) AND (dir <> 1))
   ->  Bitmap Index Scan on mm_insrel_dnumber_dir_not_one_idx  (cost=0.00..2.11 rows=30 width=0) (actual time=0.070..0.070 rows=2 loops=1)
         Index Cond: (dnumber = 558332)
 Total runtime: 0.238 ms
(5 rows)

begin;
drop index mm_insrel_dnumber_dir_not_one_idx;
explain analyze select * from mm_insrel_table where dnumber=558332 and dir<>1;
rollback;
                                                            QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------
 Bitmap Heap Scan on mm_insrel_table  (cost=2.11..113.50 rows=30 width=20) (actual time=0.084..0.091 rows=2 loops=1)
   Recheck Cond: ((dnumber = 558332) AND (dir <> 1))
   ->  Bitmap Index Scan on mm_insrel_dir_not_one_idx  (cost=0.00..2.11 rows=30 width=0) (actual time=0.067..0.067 rows=2 loops=1)
         Index Cond: (dnumber = 558332)
 Total runtime: 0.226 ms
(5 rows)

begin;
drop index mm_insrel_dnumber_dir_not_one_idx;
drop index mm_insrel_dir_not_one_idx;
explain analyze select * from mm_insrel_table where dnumber=558332 and dir<>1;
rollback;
                                                                 QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------------------------
 Index Scan using mm_insrel_full_idx on mm_insrel_table  (cost=0.00..2533.97 rows=30 width=20) (actual time=43.965..162.962 rows=2 loops=1)
   Index Cond: (dnumber = 558332)
 Total runtime: 163.085 ms
(3 rows)

begin;
drop index mm_insrel_dnumber_dir_not_one_idx;
drop index mm_insrel_dir_not_one_idx;
drop index mm_insrel_full_idx;
explain analyze select * from mm_insrel_table where dnumber=558332 and dir<>1;
rollback;
                                                                   QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------
 Index Scan using mm_insrel_relation_idx on mm_insrel_table  (cost=0.00..3102.97 rows=30 width=20) (actual time=44.608..164.894 rows=2 loops=1)
   Index Cond: (dnumber = 558332)
   Filter: (dir <> 1)
 Total runtime: 165.025 ms
(4 rows)

begin;
drop index mm_insrel_dnumber_dir_not_one_idx;
drop index mm_insrel_dir_not_one_idx;
drop index mm_insrel_full_idx;
drop index mm_insrel_relation_idx;
explain analyze select * from mm_insrel_table where dnumber=558332 and dir<>1;
rollback;
                                           QUERY PLAN
------------------------------------------------------------------------------------------------------------------
 Seq Scan on mm_insrel_table  (cost=0.00..8160.42 rows=30 width=20) (actual time=855.286..884.919 rows=2 loops=1)
   Filter: ((dnumber = 558332) AND (dir <> 1))
 Total runtime: 885.042 ms
(3 rows)