Hash Semi Join  (cost=2.50..20.69 rows=500 width=416) (actual time=1556.122..1568.130 rows=2 loops=1)
  Output: deduction_matching_get_deductions.deduction_id, deduction_matching_get_deductions.deduction_number, deduction_matching_get_deductions.distributor_company_id, deduction_matching_get_deductions.distributor_name, deduction_matching_get_deductions.distributor_number, deduction_matching_get_deductions.deduction_distributor_invoice_number, deduction_matching_get_deductions.deduction_date_created, deduction_matching_get_deductions.deduction_amount_requested, deduction_matching_get_deductions.deduction_amount_remaining, deduction_matching_get_deductions.deduction_active_state, deduction_matching_get_deductions.deduction_state, deduction_matching_get_deductions.deduction_balance_allowed_state, deduction_matching_get_deductions.deduction_balance_requested_state, deduction_matching_get_deductions.deduction_reliability_state, deduction_matching_get_deductions.client_deduction_amount_open, deduction_matching_get_deductions.client_deduction_reason_major, deduction_matching_get_deductions.client_deduction_reason_minor, deduction_matching_get_deductions.deduction_label, deduction_matching_get_deductions.client_check_number, deduction_matching_get_deductions.deduction_comment, deduction_matching_get_deductions.aged_days
  Hash Cond: (deduction_matching_get_deductions.deduction_id = unnest.unnest)
  Buffers: shared hit=190737, temp read=1853 written=1853
  ->  Function Scan on gosimple.deduction_matching_get_deductions  (cost=0.25..10.25 rows=1000 width=416) (actual time=1554.304..1562.121 rows=44351 loops=1)
        Output: deduction_matching_get_deductions.deduction_id, deduction_matching_get_deductions.deduction_number, deduction_matching_get_deductions.distributor_company_id, deduction_matching_get_deductions.distributor_name, deduction_matching_get_deductions.distributor_number, deduction_matching_get_deductions.deduction_distributor_invoice_number, deduction_matching_get_deductions.deduction_date_created, deduction_matching_get_deductions.deduction_amount_requested, deduction_matching_get_deductions.deduction_amount_remaining, deduction_matching_get_deductions.deduction_active_state, deduction_matching_get_deductions.deduction_state, deduction_matching_get_deductions.deduction_balance_allowed_state, deduction_matching_get_deductions.deduction_balance_requested_state, deduction_matching_get_deductions.deduction_reliability_state, deduction_matching_get_deductions.client_deduction_amount_open, deduction_matching_get_deductions.client_deduction_reason_major, deduction_matching_get_deductions.client_deduction_reason_minor, deduction_matching_get_deductions.deduction_label, deduction_matching_get_deductions.client_check_number, deduction_matching_get_deductions.deduction_comment, deduction_matching_get_deductions.aged_days
        Function Call: gosimple.deduction_matching_get_deductions()
        Buffers: shared hit=190737, temp read=1853 written=1853
  ->  Hash  (cost=1.00..1.00 rows=100 width=16) (actual time=0.011..0.012 rows=2 loops=1)
        Output: unnest.unnest
        Buckets: 1024  Batches: 1  Memory Usage: 9kB
        ->  Function Scan on pg_catalog.unnest  (cost=0.00..1.00 rows=100 width=16) (actual time=0.008..0.009 rows=2 loops=1)
              Output: unnest.unnest
              Function Call: unnest('{889eb05b-982b-4241-a8d3-e4f2abd1f9dc,20e6f6ef-c979-4efc-acbc-ba87608a8d94}'::uuid[])
Planning time: 1.208 ms
Execution time: 1572.626 ms