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