explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7HWx

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

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

5. 0.000 0.000 ↓ 0.0 1 1

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

  • Sort Key: (((s.geometry)::geography <-> '0104000020E6100000020000000101000000948CF73E307F52C0CAFB389A236144400101000000948CF73E307F52C0B2A03028D3344140'::geography))
  • Sort Method: top-N heapsort Memory: 25kB
6. 0.000 0.000 ↓ 0.0 47,950,918 1

Seq Scan on streets_2019_06 s (cost=0..0 rows=0 width=0) (actual rows=47,950,918 loops=1)

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