explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dTl8

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

Limit (cost=0..0 rows=0 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

Subquery Scan on str (cost=0..0 rows=0 width=0) (never executed)

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

Limit (cost=0..0 rows=0 width=0) (never executed)

4. 0.000 0.000 ↓ 0.0

Index Scan using streets_2019_06_geography on streets_2019_06 s (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((road_class)::text <> ALL ('{Z,H}'::text[]))