---

Aggregate  (cost=26373.58..26373.59 rows=1 width=8) (actual rows=1 loops=1)
  Buffers: shared hit=16134 read=4940
  I/O Timings: shared read=86.732
  InitPlan 1
    ->  Index Scan using operation_type_code_key on operation_type  (cost=0.27..2.49 rows=1 width=4) (actual rows=1 loops=1)
          Index Cond: ((code)::text = 'CHARGE_FROM_RESERVE'::text)
          Buffers: shared hit=2 read=1
          I/O Timings: shared read=0.891
  ->  Bitmap Heap Scan on operation o  (cost=16985.64..26349.96 rows=8453 width=0) (actual rows=435708 loops=1)
        Recheck Cond: ((ops_assignee_decision_id IS NOT NULL) AND (operation_type_id = (InitPlan 1).col1))
        Filter: ((approved IS NOT NULL) AND (deleted IS NULL) AND (effective_date <= CURRENT_DATE))
        Rows Removed by Filter: 10551
        Heap Blocks: exact=16145
        Buffers: shared hit=16134 read=4940
        I/O Timings: shared read=86.732
        ->  BitmapAnd  (cost=16985.64..16985.64 rows=8456 width=0) (actual rows=0 loops=1)
              Buffers: shared hit=6 read=4923
              I/O Timings: shared read=86.217
              ->  Bitmap Index Scan on ind_operation_ops_assignee_decision_id  (cost=0.00..3856.64 rows=456649 width=0) (actual rows=446277 loops=1)
                    Index Cond: (ops_assignee_decision_id IS NOT NULL)
                    Buffers: shared hit=4 read=1203
                    I/O Timings: shared read=32.495
              ->  Bitmap Index Scan on ind_operation_operation_type_id  (cost=0.00..13124.53 rows=1556408 width=0) (actual rows=4412946 loops=1)
                    Index Cond: (operation_type_id = (InitPlan 1).col1)
                    Buffers: shared hit=2 read=3720
                    I/O Timings: shared read=53.721
Planning:
  Buffers: shared hit=9
Planning Time: 0.822 ms
Execution Time: 526.097 ms