explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FPD10

Settings

Optimization(s) for this plan:

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

XN Hash Full Join DS_DIST_NONE (cost=2,086,720.43..110,019,345,775,236.91 rows=523,900,862,898,077 width=102) (actual rows= loops=)

  • Hash Cond: (("outer".claim_id)::text = ("inner".claim_id)::text)
2. 0.000 0.000 ↓ 0.0

XN Subquery Scan b (cost=0.00..152,647,180.58 rows=2,809,354,222 width=51) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

XN Unique (cost=0.00..124,553,638.36 rows=2,809,354,222 width=24) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

XN Seq Scan on raw_celgene_onc_dx_fact (cost=0.00..117,530,252.80 rows=2,809,354,222 width=24) (actual rows= loops=)

  • Filter: (service_date >= '2017-01-01'::date)
5. 0.000 0.000 ↓ 0.0

XN Hash (cost=1,993,478.21..1,993,478.21 rows=37,296,889 width=51) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Subquery Scan a (cost=0.00..1,993,478.21 rows=37,296,889 width=51) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

XN Unique (cost=0.00..1,620,509.32 rows=37,296,889 width=24) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Seq Scan on raw_celgene_onc_rx_fact (cost=0.00..1,527,267.10 rows=37,296,889 width=24) (actual rows= loops=)

  • Filter: (rx_fill_date >= '2017-01-01'::date)