explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ubh1

Settings
# exclusive inclusive rows x rows loops node
1. 15.110 3,244.257 ↓ 38.5 655 1

Gather (cost=2,686.00..16,786,628.67 rows=17 width=44) (actual time=49.643..3,244.257 rows=655 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 7.615 3,229.147 ↓ 31.1 218 3 / 3

Nested Loop (cost=1,686.00..16,785,626.97 rows=7 width=44) (actual time=38.674..3,229.147 rows=218 loops=3)

3. 70.524 70.524 ↑ 13.3 144 3 / 3

Parallel Seq Scan on forecast_daily fd (cost=0.00..14,561.80 rows=1,910 width=56) (actual time=19.520..70.524 rows=144 loops=3)

  • Filter: ((forecast_date >= '2018-11-01'::date) AND (forecast_date <= '2018-12-01'::date) AND (nb_hours = 24))
  • Rows Removed by Filter: 235,184
4. 1,916.640 3,151.008 ↓ 2.0 2 432 / 3

Bitmap Heap Scan on area_of_implantation ai (cost=1,686.00..8,780.65 rows=1 width=56) (actual time=16.961..21.882 rows=2 loops=432)

  • Recheck Cond: ((fd.forecast_date >= start_date) AND ((fd.forecast_date < end_date) OR (end_date IS NULL)))
  • Filter: ((area && _st_expand((fd.point)::geography, '1000'::double precision)) AND ((fd.point)::geography && _st_expand(area, '1000'::double precision)) AND _st_dwithin(area, (fd.point)::geography, '1000'::double precision, true))
  • Rows Removed by Filter: 5,478
  • Heap Blocks: exact=37,865
5. 5.616 1,234.368 ↓ 0.0 0 432 / 3

BitmapAnd (cost=1,686.00..1,686.00 rows=13,442 width=0) (actual time=8.572..8.572 rows=0 loops=432)

6. 208.656 208.656 ↑ 1.3 14,472 432 / 3

Bitmap Index Scan on area_of_implantation_btree_for_date (cost=0.00..137.99 rows=18,339 width=0) (actual time=1.449..1.449 rows=14,472 loops=432)

  • Index Cond: (fd.forecast_date >= start_date)
7. 0.288 1,020.096 ↓ 0.0 0 432 / 3

BitmapOr (cost=1,547.76..1,547.76 rows=40,326 width=0) (actual time=7.084..7.084 rows=0 loops=432)

8. 538.416 538.416 ↓ 1.3 24,049 432 / 3

Bitmap Index Scan on area_of_implantation_btree_for_date (cost=0.00..413.08 rows=18,339 width=0) (actual time=3.739..3.739 rows=24,049 loops=432)

  • Index Cond: (fd.forecast_date < end_date)
9. 481.392 481.392 ↑ 1.0 21,977 432 / 3

Bitmap Index Scan on area_of_implantation_btree_for_date (cost=0.00..1,120.92 rows=21,987 width=0) (actual time=3.343..3.343 rows=21,977 loops=432)

  • Index Cond: (end_date IS NULL)
Planning time : 0.237 ms
Execution time : 3,244.453 ms