explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YvuH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Gather (cost=7,331.09..15,431,163.27 rows=7,390,536 width=300) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,331.09..14,691,109.67 rows=3,079,390 width=300) (actual rows= loops=)

  • Hash Cond: (c.place_of_service = (s.place_of_service_code)::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,324.87..14,594,872.50 rows=3,079,390 width=242) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=6,324.30..8,434,435.58 rows=692,013 width=227) (actual rows= loops=)

  • Hash Cond: ((d.icd_type = icd.icd_type) AND (d.icd_unformatted_code = (icd.icd_unformatted_code)::text))
5. 0.000 0.000 ↓ 0.0

Parallel Append (cost=0.00..7,399,875.01 rows=136,713,715 width=21) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on medical_claims_diagnosis_long_hmkpa d (cost=0.00..6,716,306.43 rows=136,713,715 width=21) (actual rows= loops=)

  • Filter: (client_id = 3)
7. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=5,622.12..5,622.12 rows=46,812 width=216) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on icd_diagnosis icd (cost=0.00..5,622.12 rows=46,812 width=216) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Append (cost=0.57..8.79 rows=11 width=27) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using pk_medical_claims_hmkpa on medical_claims_hmkpa c (cost=0.57..8.74 rows=11 width=27) (actual rows= loops=)

  • Index Cond: ((axial_claim_id = d.axial_claim_id) AND (axial_claim_line_id = d.axial_claim_line_id))
  • Filter: (client_id = 3)
11. 0.000 0.000 ↓ 0.0

Hash (cost=4.99..4.99 rows=99 width=21) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on place_of_service s (cost=0.00..4.99 rows=99 width=21) (actual rows= loops=)