explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 4me

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.003 5.425 ↓ 0.0 0 1

Limit (cost=658.08..658.09 rows=1 width=21) (actual time=5.425..5.425 rows=0 loops=1)

2. 0.027 5.422 ↓ 0.0 0 1

Sort (cost=658.08..658.09 rows=1 width=21) (actual time=5.422..5.422 rows=0 loops=1)

  • Sort Key: (min(data_type)), word_suggested
  • Sort Method: quicksort Memory: 17kB
3. 0.004 5.395 ↓ 0.0 0 1

HashAggregate (cost=658.06..658.07 rows=1 width=21) (actual time=5.395..5.395 rows=0 loops=1)

4. 3.040 5.391 ↓ 0.0 0 1

Bitmap Heap Scan on tblajaxdove_ordered (cost=438.17..658.06 rows=1 width=21) (actual time=5.391..5.391 rows=0 loops=1)

  • Recheck Cond: ((lang)::text = 'IT'::text)
  • Filter: ((((word_search)::text ~~ 'mi%'::text) OR ((word_search)::text ~~ '% mi%'::text)) AND (bank_type = ANY ('{1,2,3,4}'::integer[])))
5. 2.351 2.351 ↑ 1.0 5195 1

Bitmap Index Scan on tblajaxdove_ordered_word_search_key (cost=0.00..438.17 rows=5195 width=0) (actual time=2.351..2.351 rows=5195 loops=1)

  • Index Cond: ((lang)::text = 'IT'::text)