explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9RxO

Settings
# exclusive inclusive rows x rows loops node
1. 335.562 10,295.341 ↓ 0.0 0 1

Gather (cost=1,000.00..414,830.22 rows=25,388 width=128) (actual time=10,055.307..10,295.341 rows=0 loops=1)

  • Output: (st_asbinary(planet_osm_line.way)), planet_osm_line.name, planet_osm_line.oneway, planet_osm_line.highway
  • Workers Planned: 6
  • Workers Launched: 1
2. 9,959.779 9,959.779 ↓ 0.0 0 2

Parallel Seq Scan on public.planet_osm_line (cost=0.00..411,291.42 rows=4,231 width=128) (actual time=9,959.779..9,959.779 rows=0 loops=2)

  • Output: st_asbinary(planet_osm_line.way), planet_osm_line.name, planet_osm_line.oneway, planet_osm_line.highway
  • Filter: ((planet_osm_line.way && '01030000A0110F0000010000000500000078F487C59FD65241CFCF985F1E885741000000000000000078F487C59FD652418BB20D5776895741000000000000000034D7FCBCF7D752418BB20D5776895741000000000000000034D7FCBCF7D75241CFCF985F1E885741000000000000000078F487C59FD65241CFCF985F1E8857410000000000000000'::geometry) AND (planet_osm_line.highway = ANY ('{primary,secondary,tertiary}'::text[])) AND ((planet_osm_line.name IS NOT NULL) OR (planet_osm_line.oneway = ANY ('{yes,true,1,-1}'::text[]))))
  • Rows Removed by Filter: 4251934
  • Worker 0: actual time=9880.844..9880.844 rows=0 loops=1
Planning time : 0.179 ms
Execution time : 10,295.375 ms