explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yqbN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 370,574.558 ↑ 1.0 1 1

Finalize Aggregate (cost=7,080,768.73..7,080,768.76 rows=1 width=8) (actual time=370,574.558..370,574.558 rows=1 loops=1)

2. 414.603 370,949.824 ↓ 1.5 3 1

Gather (cost=7,080,768.50..7,080,768.73 rows=2 width=8) (actual time=370,526.318..370,949.824 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 72.098 370,535.221 ↑ 1.0 1 3

Partial Aggregate (cost=7,079,768.50..7,079,768.53 rows=1 width=8) (actual time=370,535.220..370,535.221 rows=1 loops=3)

4. 364,738.932 370,463.123 ↓ 3.5 331,899 3

Parallel Bitmap Heap Scan on planet_osm_polygon (cost=179,019.89..7,079,530.38 rows=95,247 width=0) (actual time=9,095.028..370,463.123 rows=331,899 loops=3)

  • Recheck Cond: (way_area > '10000'::double precision)
  • Filter: (("natural" = ANY ('{water,pond}'::text[])) OR (waterway = ANY ('{basin,canal,mill_pond,pond,riverbank,stream}'::text[])))
  • Rows Removed by Filter: 5343893
  • Heap Blocks: exact=1332528
5. 5,724.191 5,724.191 ↑ 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,724.191..5,724.191 rows=17,027,377 loops=1)

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