explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qTTp : PG12 (VM) Points Within Buffer

Settings
# exclusive inclusive rows x rows loops node
1. 37.685 66.472 ↑ 1.3 630 1

Gather (cost=1,035.31..34,759.75 rows=798 width=37) (actual time=34.705..66.472 rows=630 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.053 28.787 ↑ 1.6 210 3 / 3

Nested Loop (cost=35.31..33,679.95 rows=332 width=37) (actual time=20.065..28.787 rows=210 loops=3)

3. 22.340 22.340 ↓ 0.0 0 3 / 3

Parallel Seq Scan on building_polygon b (cost=0.00..19,421.04 rows=1 width=183) (actual time=19.977..22.340 rows=0 loops=3)

  • Filter: (name = 'Pangea Coffee Roasters'::text)
  • Rows Removed by Filter: 154946
4. 6.371 6.394 ↓ 23.3 630 1 / 3

Bitmap Heap Scan on natural_point t (cost=35.31..14,258.65 rows=27 width=37) (actual time=0.251..19.183 rows=630 loops=1)

  • Filter: (("natural" = 'tree'::text) AND st_contains(st_buffer(b.way, '1000'::double precision, ''::text), way))
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=8
5. 0.023 0.023 ↓ 2.3 633 1 / 3

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

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