explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mJdK7

Settings
# exclusive inclusive rows x rows loops node
1. 19.820 190.789 ↑ 11.2 41,970 1

Nested Loop (cost=143.36..92,455.49 rows=470,061 width=178) (actual time=8.891..190.789 rows=41,970 loops=1)

2. 46.392 50.939 ↓ 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=8.836..50.939 rows=12,003 loops=1)

  • Recheck Cond: ((resourcenode)::text = 'MEC.ROLLHILL_1'::text)
  • Heap Blocks: exact=11472
3. 4.547 4.547 ↓ 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.547..4.547 rows=12,003 loops=1)

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

Append (cost=0.00..11.45 rows=52 width=57) (actual time=0.006..0.010 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. 96.024 96.024 ↑ 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.45 rows=51 width=57) (actual time=0.005..0.008 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 : 4.956 ms
Execution time : 196.453 ms