explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nyGZ : Optimization for: test; plan #ZqZ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 22.205 32,907.892 ↑ 1.0 9,936 1

Nested Loop (cost=0.28..1,157,817.75 rows=10,000 width=218) (actual time=31,594.079..32,907.892 rows=9,936 loops=1)

2. 5.687 5.687 ↑ 1.0 10,000 1

Seq Scan on test5 g1 (cost=0.00..725.00 rows=10,000 width=206) (actual time=0.012..5.687 rows=10,000 loops=1)

3. 20.000 32,880.000 ↑ 1.0 1 10,000

Limit (cost=0.28..115.69 rows=1 width=48) (actual time=3.288..3.288 rows=1 loops=10,000)

4. 32,860.000 32,860.000 ↑ 293.0 1 10,000

Index Scan using sm_lvl_geom_idx on sm_lvl g (cost=0.28..33,813.74 rows=293 width=48) (actual time=3.286..3.286 rows=1 loops=10,000)

  • Order By: (geom <-> g1.geom)
  • Filter: ((g1.se_code)::text = (se_code)::text)
  • Rows Removed by Filter: 2003