explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jk7i : PG12 (DigitalOcean) Points Within Buffer

Settings
# exclusive inclusive rows x rows loops node
1. 22.399 57.093 ↑ 1.5 703 1

Gather (cost=1,035.31..38,393.09 rows=1,065 width=37) (actual time=33.489..57.093 rows=703 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 0.039 34.694 ↑ 2.0 176 4 / 4

Nested Loop (cost=35.31..37,286.59 rows=344 width=37) (actual time=30.161..34.694 rows=176 loops=4)

3. 30.090 30.090 ↓ 0.0 0 4 / 4

Parallel Seq Scan on building_polygon b (cost=0.00..23,054.17 rows=1 width=187) (actual time=30.089..30.090 rows=0 loops=4)

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

Bitmap Heap Scan on natural_point t (cost=35.31..14,232.15 rows=27 width=37) (actual time=0.267..18.259 rows=703 loops=1)

  • Filter: (("natural" = 'tree'::text) AND st_contains(st_buffer(b.way, '1000'::double precision, ''::text), way))
  • Rows Removed by Filter: 8
  • Heap Blocks: exact=11
5. 0.022 0.022 ↓ 2.6 711 1 / 4

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

  • Index Cond: (way @ st_buffer(b.way, '1000'::double precision, ''::text))
Planning time : 0.244 ms
Execution time : 57.220 ms