explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P0cO : OSM Counties Join Points - Simplified

Settings
# exclusive inclusive rows x rows loops node
1. 543.526 41,219.552 ↑ 3.0 58,526 1

Nested Loop (cost=0.14..25,582.80 rows=177,500 width=96) (actual time=13.894..41,219.552 rows=58,526 loops=1)

2. 58.394 58.394 ↑ 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.037..58.394 rows=58,696 loops=1)

3. 40,617.632 40,617.632 ↑ 1.0 1 58,696

Index Scan using gix_counties_simple_1000_way on counties_simple1000 simple (cost=0.14..0.41 rows=1 width=6,394) (actual time=0.517..0.692 rows=1 loops=58,696)

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