explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CZXl

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 17.364 7,760.964 ↓ 44.5 1,557 1

Gather (cost=2,685.84..34,821,476.37 rows=35 width=44) (actual time=60.541..7,760.964 rows=1,557 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 13.931 7,743.600 ↓ 34.6 519 3 / 3

Nested Loop (cost=1,685.84..34,820,472.87 rows=15 width=44) (actual time=38.596..7,743.600 rows=519 loops=3)

3. 70.318 70.318 ↑ 11.5 344 3 / 3

Parallel Seq Scan on forecast_daily fd (cost=0.00..14,561.80 rows=3,964 width=56) (actual time=20.158..70.318 rows=344 loops=3)

  • Filter: ((forecast_date >= '2018-11-01'::date) AND (forecast_date <= '2019-01-01'::date) AND (nb_hours = 24))
  • Rows Removed by Filter: 234,984
4. 4,672.603 7,659.351 ↓ 2.0 2 1,033 / 3

Bitmap Heap Scan on area_of_implantation ai (cost=1,685.84..8,780.49 rows=1 width=56) (actual time=18.056..22.244 rows=2 loops=1,033)

  • 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,542
  • Heap Blocks: exact=89,492
5. 15.495 2,986.747 ↓ 0.0 0 1,033 / 3

BitmapAnd (cost=1,685.84..1,685.84 rows=13,442 width=0) (actual time=8.674..8.674 rows=0 loops=1,033)

6. 539.570 539.570 ↑ 1.2 14,676 1,033 / 3

Bitmap Index Scan on area_of_implantation_btree_for_date (cost=0.00..137.91 rows=18,339 width=0) (actual time=1.567..1.567 rows=14,676 loops=1,033)

  • Index Cond: (fd.forecast_date >= start_date)
7. 0.344 2,431.682 ↓ 0.0 0 1,033 / 3

BitmapOr (cost=1,547.68..1,547.68 rows=40,326 width=0) (actual time=7.062..7.062 rows=0 loops=1,033)

8. 1,266.458 1,266.458 ↓ 1.3 23,908 1,033 / 3

Bitmap Index Scan on area_of_implantation_btree_for_date (cost=0.00..413.00 rows=18,339 width=0) (actual time=3.678..3.678 rows=23,908 loops=1,033)

  • Index Cond: (fd.forecast_date < end_date)
9. 1,164.880 1,164.880 ↑ 1.0 21,977 1,033 / 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.383..3.383 rows=21,977 loops=1,033)

  • Index Cond: (end_date IS NULL)
Planning time : 0.305 ms
Execution time : 7,761.422 ms