explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LJ7W

Settings
# exclusive inclusive rows x rows loops node
1. 41.104 296.067 ↑ 11.2 41,970 1

Nested Loop (cost=143.36..92,649.37 rows=470,061 width=178) (actual time=6.292..296.067 rows=41,970 loops=1)

2. 58.715 62.915 ↓ 2.0 12,003 1

Bitmap Heap Scan on temp_gen_avg g (cost=143.36..19,983.50 rows=6,055 width=121) (actual time=6.263..62.915 rows=12,003 loops=1)

  • Recheck Cond: ((resourcenode)::text = 'MEC.ROLLHILL_1'::text)
  • Heap Blocks: exact=11472
3. 4.200 4.200 ↓ 2.0 12,003 1

Bitmap Index Scan on temp_gen_avg_idx2 (cost=0.00..141.84 rows=6,055 width=0) (actual time=4.200..4.200 rows=12,003 loops=1)

  • Index Cond: ((resourcenode)::text = 'MEC.ROLLHILL_1'::text)
4. 36.009 192.048 ↑ 17.3 3 12,003

Append (cost=0.00..11.48 rows=52 width=57) (actual time=0.011..0.016 rows=3 loops=12,003)

5. 0.000 0.000 ↓ 0.0 0 12,003

Seq Scan on dp_hist_gen_avg_forecast gf (cost=0.00..0.00 rows=1 width=182) (actual time=0.000..0.000 rows=0 loops=12,003)

  • Filter: ((p_region_id = 3) AND (g.sced_year = sced_year) AND (g.sced_month = sced_month) AND (g.sced_dow = sced_day_of_week) AND (g.sced_hour = sced_hour) AND (g.dispatch_type = (forecast_type)::text))
6. 156.039 156.039 ↑ 17.0 3 12,003

Index Scan using dp_hist_gen_avg_forecast_miso_idx2 on dp_hist_gen_avg_forecast_miso gf_1 (cost=0.43..11.48 rows=51 width=57) (actual time=0.009..0.013 rows=3 loops=12,003)

  • Index Cond: (((forecast_type)::text = g.dispatch_type) AND (sced_day_of_week = g.sced_dow) AND (sced_hour = g.sced_hour) AND (sced_month = g.sced_month) AND (sced_year = g.sced_year))
Planning time : 8.943 ms
Execution time : 303.830 ms