explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iFoh : Pg11 PostGIS2.5 Points within Buffer

Settings
# exclusive inclusive rows x rows loops node
1. 17.965 64.633 ↓ 2.0 706 1

Gather (cost=1,010.33..26,590.46 rows=355 width=37) (actual time=33.645..64.633 rows=706 loops=1)

  • Output: t."natural", t.way
  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=21117
2. 0.000 46.668 ↓ 1.6 235 3

Nested Loop (cost=10.33..25,554.96 rows=148 width=37) (actual time=38.224..46.668 rows=235 loops=3)

  • Output: t."natural", t.way
  • Buffers: shared hit=21117
  • Worker 0: actual time=40.731..40.732 rows=0 loops=1
  • Buffers: shared hit=6457
  • Worker 1: actual time=40.735..40.736 rows=0 loops=1
  • Buffers: shared hit=7364
3. 38.094 38.094 ↓ 0.0 0 3

Parallel Seq Scan on osm.building_polygon b (cost=0.00..23,999.87 rows=2 width=187) (actual time=38.093..38.094 rows=0 loops=3)

  • Output: b.osm_id, b.housename, b.housenumber, b.building, b.name, b.place, b.levels, b.height, b.tags, b.way, b.code
  • Filter: (b.name = 'Pangea Coffee Roasters'::text)
  • Rows Removed by Filter: 185847
  • Buffers: shared hit=21096
  • Worker 0: actual time=40.730..40.730 rows=0 loops=1
  • Buffers: shared hit=6457
  • Worker 1: actual time=40.734..40.734 rows=0 loops=1
  • Buffers: shared hit=7364
4. 25.360 25.501 ↓ 7.9 706 1

Bitmap Heap Scan on osm.natural_point t (cost=10.33..776.65 rows=89 width=37) (actual time=0.371..25.501 rows=706 loops=1)

  • Output: t.osm_id, t.name, t."natural", t.elevation, t.way, t.code
  • Recheck Cond: (st_buffer(b.way, '1000'::double precision) ~ t.way)
  • Filter: ((t."natural" = 'tree'::text) AND _st_contains(st_buffer(b.way, '1000'::double precision), t.way))
  • Rows Removed by Filter: 8
  • Heap Blocks: exact=12
  • Buffers: shared hit=21
5. 0.141 0.141 ↓ 2.6 714 1

Bitmap Index Scan on gix_osm_natural_point (cost=0.00..10.31 rows=270 width=0) (actual time=0.141..0.141 rows=714 loops=1)

  • Index Cond: (st_buffer(b.way, '1000'::double precision) ~ t.way)
  • Buffers: shared hit=9
Planning time : 0.221 ms
Execution time : 64.795 ms