explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NwlD

Settings
# exclusive inclusive rows x rows loops node
1. 7.126 5,850.410 ↓ 195.0 195 1

Nested Loop Left Join (cost=24.76..242,773.16 rows=1 width=1,061) (actual time=3,310.951..5,850.410 rows=195 loops=1)

2. 2.568 5,843.284 ↓ 195.0 195 1

Nested Loop (cost=24.32..242,760.13 rows=1 width=820) (actual time=3,310.836..5,843.284 rows=195 loops=1)

3. 2.266 5,840.716 ↓ 434.0 434 1

Nested Loop Left Join (cost=23.90..242,751.67 rows=1 width=812) (actual time=1,576.562..5,840.716 rows=434 loops=1)

4. 898.866 5,838.450 ↓ 434.0 434 1

Nested Loop Left Join (cost=23.77..242,751.51 rows=1 width=696) (actual time=1,576.552..5,838.450 rows=434 loops=1)

  • Join Filter: (ipm.plan_id = pip.plan_id)
  • Rows Removed by Join Filter: 5,432,541
5. 2.575 4,939.584 ↓ 434.0 434 1

Nested Loop Left Join (cost=23.77..240,419.02 rows=1 width=653) (actual time=1,575.423..4,939.584 rows=434 loops=1)

6. 29.488 4,937.009 ↓ 434.0 434 1

Nested Loop Left Join (cost=23.50..240,418.71 rows=1 width=629) (actual time=1,575.411..4,937.009 rows=434 loops=1)

  • Join Filter: ((icm.insurance_co_id)::text = (pip.insurance_co)::text)
  • Rows Removed by Join Filter: 182,714
7. 6.968 4,907.521 ↓ 434.0 434 1

Nested Loop Left Join (cost=23.50..240,390.47 rows=1 width=605) (actual time=1,575.321..4,907.521 rows=434 loops=1)

  • Join Filter: ((cr.claim_id)::text = (icrsub.claim_id)::text)
  • Rows Removed by Join Filter: 2,585
8. 3.943 4,900.553 ↓ 434.0 434 1

Nested Loop Left Join (cost=23.07..240,385.19 rows=1 width=599) (actual time=1,575.308..4,900.553 rows=434 loops=1)

9. 1.459 4,896.610 ↓ 434.0 434 1

Nested Loop Left Join (cost=22.65..240,376.75 rows=1 width=480) (actual time=1,575.295..4,896.610 rows=434 loops=1)

  • Join Filter: ((resub.claim_id)::text = (ic.claim_id)::text)
  • Rows Removed by Join Filter: 434
10. 90.478 4,895.151 ↓ 434.0 434 1

Nested Loop Left Join (cost=1.73..240,355.79 rows=1 width=448) (actual time=1,575.216..4,895.151 rows=434 loops=1)

  • Join Filter: ((doc.doctor_id)::text = (pr.doctor)::text)
  • Rows Removed by Join Filter: 517,206
11. 4,804.673 4,804.673 ↓ 434.0 434 1

Nested Loop Left Join (cost=1.73..240,262.59 rows=1 width=434) (actual time=1,574.958..4,804.673 rows=434 loops=1)

  • Join Filter: (cat.category_id = pip.plan_type_id)
  • Rows Removed by Join Filter: 1,324,118