explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h6LS : PG11 (VM) Points Within Buffer

Settings
# exclusive inclusive rows x rows loops node
1. 0.179 74.596 ↓ 2.4 630 1

Nested Loop (cost=10.33..25,221.73 rows=266 width=37) (actual time=31.227..74.596 rows=630 loops=1)

2. 55.108 55.108 ↑ 3.0 1 1

Seq Scan on building_polygon b (cost=0.00..22,809.49 rows=3 width=184) (actual time=30.967..55.108 rows=1 loops=1)

  • Filter: (name = 'Pangea Coffee Roasters'::text)
  • Rows Removed by Filter: 464,838
3. 19.239 19.309 ↓ 7.1 630 1

Bitmap Heap Scan on natural_point t (cost=10.33..803.19 rows=89 width=37) (actual time=0.243..19.309 rows=630 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: 3
  • Heap Blocks: exact=8
4. 0.070 0.070 ↓ 2.3 633 1

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

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