explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ApUJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 83.542 ↓ 0.0 0 1

Limit (cost=1,306,602.92..1,481,137.20 rows=1 width=1,061) (actual time=83.542..83.542 rows=0 loops=1)

2. 83.541 83.541 ↓ 0.0 0 1

Hash Join (cost=1,306,602.92..1,481,137.19 rows=1 width=1,061) (actual time=83.541..83.541 rows=0 loops=1)

  • Hash Cond: (cr.latest_remittance_id = ir.remittance_id)
3. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=1,293,538.88..1,468,072.58 rows=1 width=812) (never executed)

  • Hash Cond: ((icr.remittance_id = cr.latest_remittance_id) AND ((icr.claim_id)::text = (cr.claim_id)::text))
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_claim_remittance icr (cost=0.00..123,687.68 rows=6,779,468 width=28) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,293,538.87..1,293,538.87 rows=1 width=812) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,177,366.31..1,293,538.87 rows=1 width=812) (never executed)

  • Hash Cond: (pr.op_type = otn.op_type)
7. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,177,365.17..1,293,537.73 rows=1 width=696) (never executed)

  • Hash Cond: (pip.plan_id = ipm.plan_id)
8. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,175,032.67..1,291,205.23 rows=1 width=653) (never executed)

  • Hash Cond: ((pip.sponsor_id)::text = (tpa.tpa_id)::text)
9. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,175,024.37..1,291,196.91 rows=1 width=629) (never executed)

  • Hash Cond: ((pip.insurance_co)::text = (icm.insurance_co_id)::text)
10. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=1,174,996.12..1,291,168.66 rows=1 width=605) (never executed)

  • Hash Cond: (((icrsub.claim_id)::text = (cr.claim_id)::text) AND ((icrsub.resubmission_batch_id)::text = (isb.submission_batch_id)::text))
11. 0.000 0.000 ↓ 0.0 0

Seq Scan on insurance_claim_resubmission icrsub (cost=0.00..101,788.16 rows=1,917,916 width=29) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,174,996.11..1,174,996.11 rows=1 width=599) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=935,181.96..1,174,996.11 rows=1 width=599) (never executed)

  • Hash Cond: (COALESCE((max((isb_1.submission_batch_id)::text)), (cr.latest_resubmission_id)::text) = (isb.submission_batch_id)::text)
14. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=925,785.62..1,165,599.77 rows=1 width=480) (never executed)

  • Hash Cond: ((ic.claim_id)::text = (resub.claim_id)::text)
15. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=917,696.54..1,157,510.68 rows=1 width=448) (never executed)