explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XTWX

Settings
# exclusive inclusive rows x rows loops node
1. 112.314 35,482.084 ↓ 195.0 195 1

Hash Join (cost=1,357,216.70..1,531,750.97 rows=1 width=1,061) (actual time=35,476.891..35,482.084 rows=195 loops=1)

  • Hash Cond: (cr.latest_remittance_id = ir.remittance_id)
2. 789.816 35,369.770 ↓ 434.0 434 1

Hash Right Join (cost=1,344,152.66..1,518,686.36 rows=1 width=812) (actual time=35,361.796..35,369.770 rows=434 loops=1)

  • Hash Cond: ((icr.remittance_id = cr.latest_remittance_id) AND ((icr.claim_id)::text = (cr.claim_id)::text))
3. 683.251 683.251 ↑ 1.0 6,778,285 1

Seq Scan on insurance_claim_remittance icr (cost=0.00..123,687.68 rows=6,779,468 width=28) (actual time=0.013..683.251 rows=6,778,285 loops=1)

4. 0.533 33,896.703 ↓ 434.0 434 1

Hash (cost=1,344,152.65..1,344,152.65 rows=1 width=812) (actual time=33,896.703..33,896.703 rows=434 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 272kB
5. 0.269 33,896.170 ↓ 434.0 434 1

Hash Left Join (cost=1,227,980.08..1,344,152.65 rows=1 width=812) (actual time=33,189.140..33,896.170 rows=434 loops=1)

  • Hash Cond: (pr.op_type = otn.op_type)
6. 20.727 33,895.901 ↓ 434.0 434 1

Hash Left Join (cost=1,227,978.95..1,344,151.51 rows=1 width=696) (actual time=33,189.109..33,895.901 rows=434 loops=1)

  • Hash Cond: (pip.plan_id = ipm.plan_id)
7. 0.249 33,875.174 ↓ 434.0 434 1

Hash Left Join (cost=1,225,646.45..1,341,819.01 rows=1 width=653) (actual time=33,168.620..33,875.174 rows=434 loops=1)

  • Hash Cond: ((pip.sponsor_id)::text = (tpa.tpa_id)::text)
8. 0.555 33,874.925 ↓ 434.0 434 1

Hash Left Join (cost=1,225,638.15..1,341,810.69 rows=1 width=629) (actual time=33,168.580..33,874.925 rows=434 loops=1)

  • Hash Cond: ((pip.insurance_co)::text = (icm.insurance_co_id)::text)
9. 262.780 33,874.370 ↓ 434.0 434 1

Hash Right Join (cost=1,225,609.90..1,341,782.44 rows=1 width=605) (actual time=33,168.264..33,874.370 rows=434 loops=1)

  • Hash Cond: (((icrsub.claim_id)::text = (cr.claim_id)::text) AND ((icrsub.resubmission_batch_id)::text = (isb.submission_batch_id)::text))
10. 450.537 450.537 ↑ 1.0 1,917,808 1

Seq Scan on insurance_claim_resubmission icrsub (cost=0.00..101,788.16 rows=1,917,916 width=29) (actual time=0.010..450.537 rows=1,917,808 loops=1)

11. 33,161.053 33,161.053 ↓ 434.0 434 1

Hash (cost=1,225,609.89..1,225,609.89 rows=1 width=599) (actual time=33,161.053..33,161.053 rows=434 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 206kB