explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QPDh

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 55.055 ↑ 34.2 12 1

Sort (cost=690.11..690.31 rows=410 width=12) (actual time=55.055..55.055 rows=12 loops=1)

  • Sort Key: ((building_search_words.word OPERATOR(extensions.<->) 'hudsonn'::text))
  • Sort Method: quicksort Memory: 25kB
2. 0.059 55.022 ↑ 34.2 12 1

Bitmap Heap Scan on building_search_words building_search_words (cost=8.90..686.55 rows=410 width=12) (actual time=54.996..55.022 rows=12 loops=1)

3. 54.963 54.963 ↑ 34.2 12 1

Bitmap Index Scan on building_search_words_idx_wordtwo (cost=0.00..8.88 rows=410 width=0) (actual time=54.963..54.963 rows=12 loops=1)

  • Index Cond: (building_search_words.word OPERATOR(extensions.%) 'hudsonn'::text)