explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Li1h : PG11 (DigitalOcean) Points Within Buffer

Settings
# exclusive inclusive rows x rows loops node
1. 43.235 111.936 ↓ 2.0 703 1

Gather (cost=1,010.33..25,135.26 rows=355 width=37) (actual time=100.265..111.936 rows=703 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 0.051 68.701 ↓ 1.5 176 4 / 4

Nested Loop (cost=10.33..24,099.76 rows=115 width=37) (actual time=61.648..68.701 rows=176 loops=4)

3. 61.599 61.599 ↓ 0.0 0 4 / 4

Parallel Seq Scan on building_polygon b (cost=0.00..23,322.17 rows=1 width=187) (actual time=61.464..61.599 rows=0 loops=4)

  • Filter: (name = 'Pangea Coffee Roasters'::text)
  • Rows Removed by Filter: 139,262
4. 7.002 7.051 ↓ 7.9 703 1 / 4

Bitmap Heap Scan on natural_point t (cost=10.33..776.69 rows=89 width=37) (actual time=0.712..28.205 rows=703 loops=1)

  • Recheck Cond: (st_buffer(b.way, '1000'::double precision) ~ way)
  • Filter: (("natural" = 'tree'::text) AND _st_contains(st_buffer(b.way, '1000'::double precision), way))
  • Rows Removed by Filter: 8
5. 0.049 0.049 ↓ 2.6 711 1 / 4

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

  • Index Cond: (st_buffer(b.way, '1000'::double precision) ~ way)
Planning time : 0.261 ms
Execution time : 112.050 ms