explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n7eE : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #LOe; plan #ZZGj; plan #gmfp; plan #x3qQ; plan #hnoq; plan #CycZ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.040 59.898 ↑ 37.5 2 1

Bitmap Heap Scan on mv_l_areas_autocomplete (cost=9.30..291.58 rows=75 width=71) (actual time=59.889..59.898 rows=2 loops=1)

  • Recheck Cond: ((search_area_name ~~ unaccent('%remez%'::text)) OR ((area_code)::text = 'remez'::text))
  • Heap Blocks: exact=2
2. 0.007 59.858 ↓ 0.0 0 1

BitmapOr (cost=9.30..9.30 rows=75 width=0) (actual time=59.857..59.858 rows=0 loops=1)

3. 59.829 59.829 ↑ 36.5 2 1

Bitmap Index Scan on index_search_area_name_trgm (cost=0.00..4.84 rows=73 width=0) (actual time=59.828..59.829 rows=2 loops=1)

  • Index Cond: (search_area_name ~~ unaccent('%remez%'::text))
4. 0.022 0.022 ↓ 0.0 0 1

Bitmap Index Scan on index_search_area_code (cost=0.00..4.43 rows=1 width=0) (actual time=0.020..0.022 rows=0 loops=1)

  • Index Cond: ((area_code)::text = 'remez'::text)
Planning time : 0.311 ms
Execution time : 60.014 ms