explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rbAP

Settings
# exclusive inclusive rows x rows loops node
1. 76.505 26,395.544 ↓ 195.0 195 1

Hash Join (cost=1,357,216.70..1,531,750.97 rows=1 width=1,061) (actual time=26,389.875..26,395.544 rows=195 loops=1)

  • Hash Cond: (cr.latest_remittance_id = ir.remittance_id)
2. 818.008 26,319.039 ↓ 434.0 434 1

Hash Right Join (cost=1,344,152.66..1,518,686.36 rows=1 width=812) (actual time=26,310.340..26,319.039 rows=434 loops=1)

  • Hash Cond: ((icr.remittance_id = cr.latest_remittance_id) AND ((icr.claim_id)::text = (cr.claim_id)::text))
3. 818.904 818.904 ↑ 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.334..818.904 rows=6,778,285 loops=1)

4. 0.687 24,682.127 ↓ 434.0 434 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 272kB
5. 0.594 24,681.440 ↓ 434.0 434 1

Hash Left Join (cost=1,227,980.08..1,344,152.65 rows=1 width=812) (actual time=23,435.187..24,681.440 rows=434 loops=1)

  • Hash Cond: (pr.op_type = otn.op_type)
6. 27.252 24,680.846 ↓ 434.0 434 1

Hash Left Join (cost=1,227,978.95..1,344,151.51 rows=1 width=696) (actual time=23,434.844..24,680.846 rows=434 loops=1)

  • Hash Cond: (pip.plan_id = ipm.plan_id)
7. 3.108 24,653.594 ↓ 434.0 434 1

Hash Left Join (cost=1,225,646.45..1,341,819.01 rows=1 width=653) (actual time=23,407.845..24,653.594 rows=434 loops=1)

  • Hash Cond: ((pip.sponsor_id)::text = (tpa.tpa_id)::text)
8. 1.868 24,650.486 ↓ 434.0 434 1

Hash Left Join (cost=1,225,638.15..1,341,810.69 rows=1 width=629) (actual time=23,404.959..24,650.486 rows=434 loops=1)

  • Hash Cond: ((pip.insurance_co)::text = (icm.insurance_co_id)::text)
9. 291.020 24,648.618 ↓ 434.0 434 1

Hash Right Join (cost=1,225,609.90..1,341,782.44 rows=1 width=605) (actual time=23,403.310..24,648.618 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. 963.540 963.540 ↑ 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.318..963.540 rows=1,917,808 loops=1)

11. 23,394.058 23,394.058 ↓ 434.0 434 1

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

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