explain.depesz.com

PostgreSQL's explain analyze made readable

Result: egYs

Settings
# exclusive inclusive rows x rows loops node
1. 0.042 736.054 ↑ 10.2 10 1

HashAggregate (cost=611.11..613.41 rows=102 width=407) (actual time=736.050..736.054 rows=10 loops=1)

  • Output: id, name, length, (_st_asgeojson(1, linestring, 15, 0)), (_st_asgeojson(1, st_closestpoint(st_centroid(linestring), linestring), 15, 0)), (_st_asgeojson(1, point, 15, 0))
  • Buffers: shared hit=1120 read=89
2. 113.844 736.012 ↑ 10.2 10 1

Bitmap Heap Scan on public.street_extractor_result (cost=204.79..609.58 rows=102 width=407) (actual time=644.764..736.012 rows=10 loops=1)

  • Output: id, name, length, _st_asgeojson(1, linestring, 15, 0), _st_asgeojson(1, st_closestpoint(st_centroid(linestring), linestring), 15, 0), _st_asgeojson(1, point, 15, 0)
  • Recheck Cond: (street_extractor_result.name ~~* 'kaufunger str%'::text)
  • Buffers: shared hit=1120 read=89
3. 622.168 622.168 ↑ 10.2 10 1

Bitmap Index Scan on trgm_idx_street_extractor_result_name (cost=0.00..204.77 rows=102 width=0) (actual time=622.168..622.168 rows=10 loops=1)

  • Index Cond: (street_extractor_result.name ~~* 'kaufunger str%'::text)
  • Buffers: shared hit=1120 read=86