explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p3Su

Settings
# exclusive inclusive rows x rows loops node
1. 10,785.418 95,643.447 ↓ 361,672.0 361,672 1

Nested Loop (cost=100.01..365.93 rows=1 width=72) (actual time=27.079..95,643.447 rows=361,672 loops=1)

  • Join Filter: ((n.geom && st_expand(sp.geom, '10000'::double precision)) AND (sp.geom && st_expand(n.geom, '10000'::double precision)) AND _st_dwithin(n.geom, sp.geom, '10000'::double precision))
  • Rows Removed by Join Filter: 21531788
2.          

CTE sp

3. 0.001 0.001 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)

4. 0.003 0.003 ↑ 1.0 1 1

CTE Scan on sp (cost=0.00..0.02 rows=1 width=32) (actual time=0.002..0.003 rows=1 loops=1)

5. 84,858.026 84,858.026 ↓ 25,666.4 21,893,460 1

Foreign Scan on network n (cost=100.00..135.59 rows=853 width=72) (actual time=20.017..84,858.026 rows=21,893,460 loops=1)

Planning time : 11.098 ms
Execution time : 95,671.287 ms