explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Xcrl : Optimization for: plan #V4Hv

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 549.968 22,046.788 ↑ 1.1 13,978 1

GroupAggregate (cost=1,001.03..31,589.34 rows=15,925 width=311) (actual time=70.414..22,046.788 rows=13,978 loops=1)

  • Group Key: p.guid
2. 0.000 21,496.820 ↓ 3.8 60,390 1

Gather Merge (cost=1,001.03..30,136.19 rows=15,925 width=231) (actual time=69.353..21,496.820 rows=60,390 loops=1)

  • Workers Planned: 16
  • Workers Launched: 16
3. 26.693 106,266.150 ↓ 3.6 3,552 17

Nested Loop (cost=0.69..27,098.44 rows=995 width=231) (actual time=0.400..6,250.950 rows=3,552 loops=17)

4. 26.350 26.350 ↑ 1.1 951 17

Parallel Index Scan using geom_portal_pkey on geom_portal p (cost=0.41..513.70 rows=1,010 width=87) (actual time=0.016..1.550 rows=951 loops=17)

5. 106,213.107 106,213.107 ↓ 4.0 4 16,159

Index Scan using planet_osm_polygon_way_idx1 on planet_osm_polygon a (cost=0.28..26.31 rows=1 width=418) (actual time=0.341..6.573 rows=4 loops=16,159)

  • Index Cond: (way && p.loc)
  • Filter: st_intersects(way, p.loc)
  • Rows Removed by Filter: 2
Planning time : 0.794 ms
Execution time : 22,051.912 ms