explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iajo

Settings
# exclusive inclusive rows x rows loops node
1. 4.474 11.901 ↓ 3,581.3 10,744 1

Nested Loop Left Join (cost=0.28..532.55 rows=3 width=44) (actual time=0.241..11.901 rows=10,744 loops=1)

  • Output: deduction.deduction_id, deduction_claim.claim_id, deduction.deduction_amount_requested, deduction_claim.deduction_amount_allotted
  • Join Filter: (deduction.deduction_id = deduction_claim.deduction_id)
  • Buffers: shared hit=197
2. 0.019 0.019 ↑ 1.0 1 1

Index Scan using deduction_pkey on client_stonyfield.deduction (cost=0.28..3.30 rows=1 width=22) (actual time=0.015..0.019 rows=1 loops=1)

  • Output: deduction.deduction_id, deduction.client_id, deduction.source_row_id, deduction.deduction_number, deduction.company_id, deduction.distributor_invoice_number, deduction.deduction_date_created, deduction.deduction_amount_requested, deduction.client_deduction_amount_open, deduction.client_deduction_reason_major, deduction.client_deduction_reason_minor, deduction.deduction_active_state, deduction.client_check_number, deduction.deduction_label, deduction.deduction_comment, deduction.client_deduction_comment, deduction.bill_to_company_number, deduction.ship_to_company_number, deduction.deduction_date_closed
  • Index Cond: (deduction.deduction_id = '41ce5e9e-ff1c-4691-b0d7-13c3a87cb1f5'::uuid)
  • Buffers: shared hit=3
3. 7.408 7.408 ↑ 1.0 10,744 1

Seq Scan on client_stonyfield.deduction_claim (cost=0.00..394.95 rows=10,744 width=38) (actual time=0.222..7.408 rows=10,744 loops=1)

  • Output: deduction_claim.deduction_id, deduction_claim.claim_id, deduction_claim.deduction_amount_allotted, deduction_claim.active_range, deduction_claim.inoperative, deduction_claim.deduction_claim_id, deduction_claim.match_account_id, deduction_claim.unmatch_account_id
  • Filter: ((deduction_claim.deduction_id = '41ce5e9e-ff1c-4691-b0d7-13c3a87cb1f5'::uuid) AND (deduction_claim.active_range @> now()))
  • Rows Removed by Filter: 739
  • Buffers: shared hit=194