explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ehcr

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

XN Hash Join DS_DIST_ALL_NONE (cost=973,969.14..1,237,395.97 rows=284 width=41) (actual rows= loops=)

  • Hash Cond: ((("outer".kpi_id)::text = ("inner".aeic)::text) AND ("outer".fact_id = "inner".fact_id))
  • Join Filter: (("inner".serie_ts <= "outer".to_ts) AND ("inner".serie_ts >= "outer".from_ts))
2. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=3,025.68..8,438.75 rows=1 width=28) (actual rows= loops=)

  • Hash Cond: ((("outer".id)::text = ("inner".aeic)::text) AND ("outer".kpi_id = "inner".kpi_id) AND ("outer".fact_id = "inner".fact_id))
  • Join Filter: (("inner".to_ts < "outer".mapping_end) AND ("inner".from_ts >= "outer".mapping_start))
3. 0.000 0.000 ↓ 0.0

XN Hash Join DS_DIST_ALL_NONE (cost=0.15..5,413.18 rows=1 width=34) (actual rows= loops=)

  • Hash Cond: (("outer".gpn)::text = ("inner".kpi_name)::text)
4. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map g (cost=0.00..5,407.74 rows=422 width=43) (actual rows= loops=)

  • Filter: ('000710'::text = (id)::text)
5. 0.000 0.000 ↓ 0.0

XN Hash (cost=0.15..0.15 rows=1 width=26) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_kpi_v2 k (cost=0.00..0.15 rows=1 width=26) (actual rows= loops=)

  • Filter: ((kpi_id = 12) AND (fact_id = 7))
7. 0.000 0.000 ↓ 0.0

XN Hash (cost=3,025.51..3,025.51 rows=1 width=34) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

XN Seq Scan on asset_missing_series volt_dt_0 (cost=0.00..3,025.51 rows=1 width=34) (actual rows= loops=)

  • Filter: ((kpi_id = 12) AND ((aeic)::text = '000710'::text) AND (fact_dt = '2018-01-01'::date) AND (fact_id = 7))
9. 0.000 0.000 ↓ 0.0

XN Hash (cost=693,531.04..693,531.04 rows=55,482,484 width=45) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

XN Seq Scan on asset_facts_series s (cost=0.00..693,531.04 rows=55,482,484 width=45) (actual rows= loops=)

  • Filter: (fact_id = 7)