explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VexT : Optimization for: plan #CZXl

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 15.123 7,752.876 ↓ 43.5 1,521 1

Gather (cost=2,685.84..34,821,476.37 rows=35 width=44) (actual time=49.128..7,752.876 rows=1,521 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 16.707 7,737.753 ↓ 33.8 507 3 / 3

Nested Loop (cost=1,685.84..34,820,472.87 rows=15 width=44) (actual time=40.246..7,737.753 rows=507 loops=3)

3. 67.893 67.893 ↑ 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=18.246..67.893 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,748.012 7,653.153 ↑ 1.0 1 1,033 / 3

Bitmap Heap Scan on area_of_implantation ai (cost=1,685.84..8,780.49 rows=1 width=56) (actual time=17.852..22.226 rows=1 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, '100'::double precision)) AND ((fd.point)::geography && _st_expand(area, '100'::double precision)) AND _st_dwithin(area, (fd.point)::geography, '100'::double precision, true))
  • Rows Removed by Filter: 5,542
  • Heap Blocks: exact=88,643
5. 13.773 2,905.140 ↓ 0.0 0 1,033 / 3

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

6. 513.401 513.401 ↑ 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.491..1.491 rows=14,676 loops=1,033)

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

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

8. 1,251.652 1,251.652 ↓ 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.635..3.635 rows=23,908 loops=1,033)

  • Index Cond: (fd.forecast_date < end_date)
9. 1,125.626 1,125.626 ↑ 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.269..3.269 rows=21,977 loops=1,033)

  • Index Cond: (end_date IS NULL)
Planning time : 0.256 ms
Execution time : 7,757.321 ms