explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kqXP

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 390,544.287 ↑ 1.0 1 1

Finalize Aggregate (cost=7,031,471.21..7,031,471.24 rows=1 width=8) (actual time=390,544.287..390,544.287 rows=1 loops=1)

2. 490.859 390,837.708 ↓ 1.5 3 1

Gather (cost=7,031,470.98..7,031,471.21 rows=2 width=8) (actual time=390,522.439..390,837.708 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 624.594 390,346.849 ↑ 1.0 1 3

Partial Aggregate (cost=7,030,470.98..7,030,471.01 rows=1 width=8) (actual time=390,346.848..390,346.849 rows=1 loops=3)

4. 384,049.884 389,722.255 ↑ 1.3 5,675,792 3

Parallel Bitmap Heap Scan on planet_osm_polygon (cost=183,223.81..7,012,716.54 rows=7,101,776 width=0) (actual time=8,872.308..389,722.255 rows=5,675,792 loops=3)

  • Recheck Cond: (way_area > '10000'::double precision)
  • Heap Blocks: exact=1409575
5. 5,672.371 5,672.371 ↑ 1.0 17,027,377 1

Bitmap Index Scan on "Prova_Idx" (cost=0.00..178,962.74 rows=17,044,263 width=0) (actual time=5,672.371..5,672.371 rows=17,027,377 loops=1)

  • Index Cond: (way_area > '10000'::double precision)
Planning time : 0.136 ms