explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ACPf

Settings
# exclusive inclusive rows x rows loops node
1. 2.588 6.050 ↓ 10,744.0 10,744 1

Nested Loop Left Join (cost=0.57..310.25 rows=1 width=44) (actual time=0.079..6.050 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=157 read=45
2. 0.012 0.012 ↑ 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.012..0.012 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. 3.450 3.450 ↓ 3.0 10,744 1

Index Scan using idx_deduction_claim_deduction_id on client_stonyfield.deduction_claim (cost=0.29..262.19 rows=3,581 width=38) (actual time=0.064..3.450 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
  • Index Cond: (deduction_claim.deduction_id = '41ce5e9e-ff1c-4691-b0d7-13c3a87cb1f5'::uuid)
  • Buffers: shared hit=154 read=45