explain.depesz.com

PostgreSQL's explain analyze made readable

Result: it2s

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

XN Hash Join DS_DIST_ALL_NONE (cost=7,495.01..7,580.75 rows=4 width=83) (actual rows= loops=)

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

XN Hash Join DS_DIST_ALL_NONE (cost=7,494.84..7,554.44 rows=1,160 width=77) (actual rows= loops=)

  • Hash Cond: (("outer".aeic)::text = ("inner".id)::text)
3. 0.000 0.000 ↓ 0.0

XN Seq Scan on dim_unit u (cost=0.00..5.63 rows=3 width=14) (actual rows= loops=)

  • Filter: (((("datasource")::text = 'SEVE10'::text) OR (("datasource")::text = 'SEVE20'::text)) AND (app_id = 1))
4. 0.000 0.000 ↓ 0.0

XN Hash (cost=6,516.06..6,516.06 rows=391,512 width=73) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

XN Seq Scan on pdc_gpn_map m (cost=0.00..6,516.06 rows=391,512 width=73) (actual rows= loops=)

  • Filter: ((mapping_end > '2019-05-05 00:00:00'::timestamp without time zone) AND (mapping_start <= '2019-05-01 00:00:00'::timestamp without time zone))
6. 0.000 0.000 ↓ 0.0

XN Hash (cost=0.15..0.15 rows=9 width=22) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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

  • Filter: ((fact_id = 25) AND ((kpi_type)::text = 'gpn'::text))