explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jsyk

Settings
# exclusive inclusive rows x rows loops node
1. 17.716 15,220.389 ↓ 8.1 77,446 1

Nested Loop (cost=0.41..355.00 rows=9,511 width=8) (actual time=3.835..15,220.389 rows=77,446 loops=1)

2. 0.019 0.019 ↑ 1.0 2 1

Seq Scan on coastal_segments segments (cost=0.00..1.02 rows=2 width=11,024) (actual time=0.015..0.019 rows=2 loops=1)

3. 15,202.654 15,202.654 ↓ 1,548.9 38,723 2

Index Scan using air_v7_50k_tracks_gist on tracks (cost=0.41..176.74 rows=25 width=2,426) (actual time=2.631..7,601.327 rows=38,723 loops=2)

  • Index Cond: (geom && segments.geom)
  • Filter: _st_intersects(geom, segments.geom)
  • Rows Removed by Filter: 77918