CREATE INDEX par_ftransac_2012_03_idxstan
  ON aus.par_ftransac_2012_03
  USING btree
  (stan)
TABLESPACE pg_default;


CREATE INDEX par_ftransac_2012_03_ndx1
  ON aus.par_ftransac_2012_03
  USING btree
  (date_transaction)
TABLESPACE tbl_index;



CREATE INDEX par_ftransac_2012_03_ndx2
  ON aus.par_ftransac_2012_03
  USING btree
  (id_client)
TABLESPACE tbl_index;



CREATE INDEX par_ftransac_2012_03_ndx3
  ON aus.par_ftransac_2012_03
  USING btree
  (id_org)
TABLESPACE tbl_index;






CREATE INDEX par_ftransac_2012_03_ndx5
  ON aus.par_ftransac_2012_03
  USING btree
  (date_transaction_one)
TABLESPACE tbl_index;

Nested Loop  (cost=0.00..4026.82 rows=2 width=2008) (actual time=9558.355..311970.675 rows=39071 loops=1)
   ->  Append  (cost=0.00..4010.26 rows=2 width=1996) (actual time=9531.171..311651.298 rows=39071 loops=1)
         ->  Seq Scan on ftransac ft  (cost=0.00..0.00 rows=1 width=1996) (actual time=0.003..0.003 rows=0 loops=1)
               Filter: (is_offline AND (date_transaction >= '2012-03-01 00:00:00'::timestamp without time zone) AND (date_transaction <= '2012-03-31 23:59:59'::timestamp without time zone) AND (id_client = 196) AND ((cashier)::text = '00000001'::text) AND (id_org = ANY ('{1686,1495,502,708,10691,921,1219,707,704,1494,710,1576,1536,1539,506,1218,504,500,1540,1545,1510,1217,1578,822,1489,1530,1738,13920,719,797,715,1506,1544,1548,1114,1493,712,717,1825,1523,713,923,1519,706,1512,922,1524,1525,1322,14901,711,1521,1568,1811,1491,705,1490,1533,1574,1527,714,718,1488,709,1492,791,716}'::integer[])))
         ->  Bitmap Heap Scan on par_ftransac_2012_03 ft  (cost=2647.42..4010.26 rows=1 width=1996) (actual time=9531.167..311639.494 rows=39071 loops=1)
               Recheck Cond: ((id_client = 196) AND (date_transaction >= '2012-03-01 00:00:00'::timestamp without time zone) AND (date_transaction <= '2012-03-31 23:59:59'::timestamp without time zone))
               Filter: (is_offline AND ((cashier)::text = '00000001'::text) AND (id_org = ANY ('{1686,1495,502,708,10691,921,1219,707,704,1494,710,1576,1536,1539,506,1218,504,500,1540,1545,1510,1217,1578,822,1489,1530,1738,13920,719,797,715,1506,1544,1548,1114,1493,712,717,1825,1523,713,923,1519,706,1512,922,1524,1525,1322,14901,711,1521,1568,1811,1491,705,1490,1533,1574,1527,714,718,1488,709,1492,791,716}'::integer[])))
               ->  BitmapAnd  (cost=2647.42..2647.42 rows=335 width=0) (actual time=8626.991..8626.991 rows=0 loops=1)
                     ->  Bitmap Index Scan on par_ftransac_2012_03_ndx2  (cost=0.00..1239.89 rows=66956 width=0) (actual time=3930.464..3930.464 rows=11877763 loops=1)
                           Index Cond: (id_client = 196)
                     ->  Bitmap Index Scan on par_ftransac_2012_03_ndx1  (cost=0.00..1407.28 rows=66956 width=0) (actual time=4166.593..4166.593 rows=13391132 loops=1)
                           Index Cond: ((date_transaction >= '2012-03-01 00:00:00'::timestamp without time zone) AND (date_transaction <= '2012-03-31 23:59:59'::timestamp without time zone))
   ->  Index Scan using org_pkey on org os  (cost=0.00..8.27 rows=1 width=16) (actual time=0.006..0.006 rows=1 loops=39071)
         Index Cond: (id_org = ft.id_org)
 Total runtime: 311985.884 ms