explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OYhZ

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

Gather (cost=1,000.00..1,265,573,830.60 rows=1 width=104) (actual rows= loops=)

  • Workers Planned: 2
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..1,265,572,830.50 rows=1 width=104) (actual rows= loops=)

  • Join Filter: ((st_transform(l.way, 4326) && q.qbbox) AND (geography(st_transform(l.way, 4326)) && _st_expand((q.qpoint)::geography, '200'::double precision)) AND ((q.qpoint)::geography && _st_expand(geography(st_transform(l.way, 4326)), '200'::double precision)) AND _st_intersects(st_transform(l.way, 4326), q.qbbox) AND _st_dwithin(geography(st_transform(l.way, 4326)), (q.qpoint)::geography, '200'::double precision, true))
3. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on north_america_line l (cost=0.00..1,909,933.44 rows=149,687 width=292) (actual rows= loops=)

  • Filter: (railway = ANY ('{subway,light_rail,funicular,rail,tram,monorail,narrow_gauge}'::text[]))
4. 0.000 0.000 ↓ 0.0

Seq Scan on query_input_table q (cost=0.00..581.87 rows=9,887 width=168) (actual rows= loops=)