explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1kjg

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

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

2. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (str.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)

  • Filter: ((road_class)::text <> ALL ('{Z,H}'::text[]))
Planning time : 0.223 ms
Execution time : 484.537 ms