explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j64K

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=0.08..2.96 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.08..815,830.27 rows=283,862 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Seq Scan on changetypebuff p (cost=0.00..69,289.33 rows=1,540,109 width=477) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using c2c_year_buff_geom_geom_idx on c2c_year_buff b (cost=0.08..0.41 rows=1 width=391) (actual rows= loops=)

  • Index Cond: ((geom && p.geom) AND (geom && p.geom))
  • Filter: (_st_intersects(geom, p.geom) AND _st_overlaps(geom, p.geom))