explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bswD

Settings
# exclusive inclusive rows x rows loops node
1. 5.997 1,568.130 ↑ 250.0 2 1

Hash Semi Join (cost=2.50..20.69 rows=500 width=416) (actual time=1,556.122..1,568.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
2. 1,562.121 1,562.121 ↓ 44.4 44,351 1

Function Scan on gosimple.deduction_matching_get_deductions (cost=0.25..10.25 rows=1,000 width=416) (actual time=1,554.304..1,562.121 rows=44,351 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
3. 0.003 0.012 ↑ 50.0 2 1

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
4. 0.009 0.009 ↑ 50.0 2 1

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 : 1,572.626 ms