explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KeS6

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

XN Merge (cost=2,001,824,300,944.44..2,001,824,300,944.79 rows=140 width=184) (actual rows= loops=)

  • Merge Key: memberuid_min, srvc_dt
2. 0.000 0.000 ↓ 0.0

XN Network (cost=2,001,824,300,944.44..2,001,824,300,944.79 rows=140 width=184) (actual rows= loops=)

  • Send to leader
3. 0.000 0.000 ↓ 0.0

XN Sort (cost=2,001,824,300,944.44..2,001,824,300,944.79 rows=140 width=184) (actual rows= loops=)

  • Sort Key: memberuid_min, srvc_dt
4. 0.000 0.000 ↓ 0.0

XN Subquery Scan claims_with_row_number (cost=1,001,824,300,919.15..1,001,824,300,939.45 rows=140 width=184) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Window (cost=1,001,824,300,919.15..1,001,824,300,938.05 rows=140 width=164) (actual rows= loops=)

  • Partition: memberuid_min
6. 0.000 0.000 ↓ 0.0

XN Window (cost=1,001,824,300,919.15..1,001,824,300,928.60 rows=140 width=164) (actual rows= loops=)

  • Partition: memberuid_min, source
  • Order: srvc_dt
7. 0.000 0.000 ↓ 0.0

XN Sort (cost=1,001,824,300,919.15..1,001,824,300,919.50 rows=140 width=164) (actual rows= loops=)

  • Sort Key: memberuid_min, source, srvc_dt
8. 0.000 0.000 ↓ 0.0

XN Subquery Scan unioned (cost=19,040.69..1,824,300,914.16 rows=140 width=164) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

XN Append (cost=19,040.69..1,824,300,912.76 rows=140 width=54) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Subquery Scan "*SELECT* 1" (cost=19,040.69..912,148,869.66 rows=70 width=54) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

XN Hash IN Join DS_BCAST_INNER (cost=19,040.69..912,148,868.96 rows=70 width=54) (actual rows= loops=)

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

XN Seq Scan on fct_d1b_claim_code cc (cost=0.00..910,911,518.72 rows=87,864,708 width=54) (actual rows= loops=)

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

XN Hash (cost=19,040.68..19,040.68 rows=1 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_d1_code (cost=0.00..19,040.68 rows=1 width=4) (actual rows= loops=)

  • Filter: (((code_value)::text = 'D595'::text) AND ((code_type)::text = 'ICD10DX'::text))
15. 0.000 0.000 ↓ 0.0

XN Subquery Scan "*SELECT* 2" (cost=22,214.14..912,152,043.11 rows=70 width=54) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

XN Hash IN Join DS_BCAST_INNER (cost=22,214.14..912,152,042.41 rows=70 width=54) (actual rows= loops=)

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

XN Seq Scan on fct_d1b_claim_code cc (cost=0.00..910,911,518.72 rows=87,864,708 width=54) (actual rows= loops=)

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

XN Hash (cost=22,214.13..22,214.13 rows=1 width=4) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_d1_code (cost=0.00..22,214.13 rows=1 width=4) (actual rows= loops=)

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