explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V4Hv

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 552.236 22,170.029 ↑ 1.1 13,978 1

GroupAggregate (cost=1,001.04..2,131,886.61 rows=15,925 width=311) (actual time=1,443.381..22,170.029 rows=13,978 loops=1)

  • Group Key: p.guid
  • Functions: 139
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 76.763 ms, Inlining 803.664 ms, Optimization 11958.699 ms, Emission 6625.573 ms, Total 19464.699 ms
2. 0.000 21,617.793 ↓ 3.8 60,390 1

Gather Merge (cost=1,001.04..2,130,433.46 rows=15,925 width=231) (actual time=1,442.440..21,617.793 rows=60,390 loops=1)

  • Workers Planned: 16
  • Workers Launched: 16
3. 19,435.200 119,692.597 ↓ 3.6 3,552 17

Nested Loop (cost=0.70..2,127,395.71 rows=995 width=231) (actual time=1,141.835..7,040.741 rows=3,552 loops=17)

4. 23.120 23.120 ↑ 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.022..1.360 rows=951 loops=17)

5. 100,234.277 100,234.277 ↓ 4.0 4 16,159

Index Scan using planet_osm_polygon_way_idx on planet_osm_polygon a (cost=0.29..2,105.81 rows=1 width=418) (actual time=0.651..6.203 rows=4 loops=16,159)

  • Index Cond: (way && p.loc)
  • Filter: ((name IS NOT NULL) AND ((boundary IS NOT NULL) OR (place = ANY ('{island,islet,archipelago}'::text[]))) AND st_intersects(way, p.loc))
  • Rows Removed by Filter: 5
Planning time : 1.140 ms
Execution time : 22,185.526 ms