explain.depesz.com

PostgreSQL's explain analyze made readable

Result: njwu : Optimization for: Optimization for: plan #V4Hv; plan #Xcrl

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 289.297 13,155.739 ↑ 1.2 13,978 1

GroupAggregate (cost=31,307.61..33,136.66 rows=16,159 width=311) (actual time=12,861.006..13,155.739 rows=13,978 loops=1)

  • Group Key: p.guid, p.name
2. 95.037 12,866.442 ↓ 3.0 60,390 1

Sort (cost=31,307.61..31,358.34 rows=20,291 width=232) (actual time=12,860.919..12,866.442 rows=60,390 loops=1)

  • Sort Key: p.guid, p.name
  • Sort Method: quicksort Memory: 12667kB
3. 166.689 12,771.405 ↓ 3.0 60,390 1

Gather (cost=1,000.27..29,855.94 rows=20,291 width=232) (actual time=3.243..12,771.405 rows=60,390 loops=1)

  • Workers Planned: 16
  • Workers Launched: 16
4. 12,590.819 12,604.716 ↓ 2.8 3,552 17

Nested Loop (cost=0.28..26,826.84 rows=1,268 width=232) (actual time=7.919..12,604.716 rows=3,552 loops=17)

5. 0.640 0.640 ↑ 1.1 951 17

Parallel Seq Scan on geom_portal_x p (cost=0.00..242.10 rows=1,010 width=87) (actual time=0.012..0.640 rows=951 loops=17)

6. 13.257 13.257 ↓ 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=464) (actual time=0.655..13.257 rows=4 loops=16,159)

  • Index Cond: (way && p.loc)
  • Filter: st_intersects(way, p.loc)
  • Rows Removed by Filter: 2
Planning time : 0.515 ms
Execution time : 13,157.509 ms