explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P6OOG

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

XN HashAggregate (cost=1,000,904,332,566.75..1,000,904,332,567.00 rows=100 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

XN Subquery Scan member_level (cost=1,000,904,331,959.25..1,000,904,332,566.25 rows=100 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN GroupAggregate (cost=1,000,904,331,959.25..1,000,904,332,565.25 rows=100 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Subquery Scan claims_with_member_summary_info (cost=1,000,904,331,959.25..1,000,904,332,524.15 rows=8,070 width=12) (actual rows= loops=)

  • Filter: ((has_codeset_1)::boolean = true)
5. 0.000 0.000 ↓ 0.0

XN Window (cost=1,000,904,331,959.25..1,000,904,332,282.05 rows=16,140 width=20) (actual rows= loops=)

  • Partition: claims.memberuid_min
  • Order: claims.srvc_dt
6. 0.000 0.000 ↓ 0.0

XN Sort (cost=1,000,904,331,959.25..1,000,904,331,999.60 rows=16,140 width=20) (actual rows= loops=)

  • Sort Key: claims.memberuid_min, claims.srvc_dt
7. 0.000 0.000 ↓ 0.0

XN Hash Join DS_BCAST_INNER (cost=28,561.06..904,330,831.20 rows=16,140 width=20) (actual rows= loops=)

  • Hash Cond: ("outer".code_key = "inner".code_key)
8. 0.000 0.000 ↓ 0.0

XN Seq Scan on fct_d1b_claim_code claims (cost=0.00..780,781,301.76 rows=9,865,664,558 width=12) (actual rows= loops=)

  • Filter: ((srvc_dt >= '2019-01-01'::date) AND (srvc_dt < '2020-04-01'::date))
9. 0.000 0.000 ↓ 0.0

XN Hash (cost=28,561.06..28,561.06 rows=1 width=12) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Subquery Scan codesets_new (cost=28,561.03..28,561.06 rows=1 width=12) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN HashAggregate (cost=28,561.03..28,561.05 rows=1 width=24) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_d1_code (cost=0.00..28,561.03 rows=1 width=24) (actual rows= loops=)

  • Filter: (((((code_value)::text = 'C9052'::text) OR ((code_value)::text = 'J1303'::text)) AND ((code_type)::text = 'HCPCS'::text)) OR (((code_value)::text = 'D595'::text) AND ((code_type)::text = 'ICD10DX'::text)))