explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 3N1

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.026 487.711 ↑ 1.0 30 1

Limit (cost=8,300.16..8,300.24 rows=30 width=28) (actual time=487.674..487.711 rows=30 loops=1)

  • Output: word_suggested, (min(data_type))
  • Buffers: shared hit=2700
2. 2.857 487.685 ↑ 26.3 30 1

Sort (cost=8,300.16..8,302.13 rows=788 width=28) (actual time=487.671..487.685 rows=30 loops=1)

  • Output: word_suggested, (min(data_type))
  • Sort Key: (min(tblajaxdove_ordered.data_type)), tblajaxdove_ordered.word_suggested
  • Sort Method: top-N heapsort Memory: 18kB
  • Buffers: shared hit=2700
3. 7.223 484.828 ↓ 2.6 2,060 1

HashAggregate (cost=8,269.01..8,276.89 rows=788 width=28) (actual time=483.377..484.828 rows=2,060 loops=1)

  • Output: word_suggested, min(data_type)
  • Buffers: shared hit=2700
4. 477.605 477.605 ↓ 1.0 2,061 1

Seq Scan on public.tblajaxdove_ordered (cost=0.00..8,259.10 rows=1,982 width=28) (actual time=28.429..477.605 rows=2,061 loops=1)

  • Output: id, word_search, word_suggested, data_type, bank_type, lang, word_search_low
  • Filter: (((tblajaxdove_ordered.lang)::text = 'IT'::text) AND (((tblajaxdove_ordered.word_search)::text ~~* 'mi%'::text) OR ((tblajaxdove_ordered.word_search)::text ~~* '% mi%'::text)) AND ((tblajaxdove_ordered.bank_type = 1) OR (tblajaxdove_ordered.bank_type = 2) OR (tblajaxdove_ordered.bank_type = 3) OR (tblajaxdove_ordered.bank_type = 4)))
  • Buffers: shared hit=2700