explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gcXu

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

Limit (cost=1,306,591.49..1,481,125.77 rows=1 width=1,061) (actual time=156.436..156.436 rows=0 loops=1)

2. 156.435 156.435 ↓ 0.0 0 1

Hash Join (cost=1,306,591.49..1,481,125.76 rows=1 width=1,061) (actual time=156.435..156.435 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,527.45..1,468,061.15 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,527.44..1,293,527.44 rows=1 width=812) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=1,177,354.88..1,293,527.44 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,353.74..1,293,526.30 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,021.24..1,291,193.80 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,012.94..1,291,185.48 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,984.69..1,291,157.23 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,984.68..1,174,984.68 rows=1 width=599) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=935,181.96..1,174,984.68 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,588.34 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,499.25 rows=1 width=448) (never executed)

  • 1,126 Top