explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZNkv

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

XN Hash Join DS_DIST_ALL_NONE (cost=8,434.31..8,438.75 rows=1 width=83) (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))
2. 0.000 0.000 ↓ 0.0

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

  • Hash Cond: (("outer".kpi_name)::text = ("inner".gpn)::text)
3. 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))
4. 0.000 0.000 ↓ 0.0

XN Hash (cost=5,407.74..5,407.74 rows=422 width=74) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

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

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

7. 0.000 0.000 ↓ 0.0

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

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