explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5cf5 : OSM Counties Join Points - Original

Settings
# exclusive inclusive rows x rows loops node
1. 481.085 65,556.186 ↑ 3.0 58,527 1

Nested Loop (cost=0.14..25,578.80 rows=177,499 width=96) (actual time=2.987..65,556.186 rows=58,527 loops=1)

  • Planning time: 2.232 ms
  • Execution time: 65599.722 ms
2. 98.629 98.629 ↑ 1.0 58,696 1

Seq Scan on natural_point p (cost=0.00..1,143.96 rows=58,696 width=96) (actual time=0.039..98.629 rows=58,696 loops=1)

3. 64,976.472 64,976.472 ↑ 1.0 1 58,696

Index Scan using gix_counties_way on counties orig (cost=0.14..0.41 rows=1 width=11,589) (actual time=0.817..1.107 rows=1 loops=58,696)

  • Index Cond: (way && p.way)
  • Filter: _st_intersects(way, p.way)
  • Rows Removed by Filter: 1