explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JKZ7

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

Limit (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

2. 0.000 0.000 ↓ 0.0 1 1

Subquery Scan on outertable (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

  • Filter: (outertable.distance <= '1609.4'::double precision)
3. 0.000 0.000 ↓ 0.0 1 1

Limit (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

4. 0.000 0.000 ↓ 0.0 1 1

Index Scan using streets_2019_06_geography on streets_2019_06 s (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

Planning time : 0.161 ms
Execution time : 3,783.558 ms