explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9mhv

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.722 ↑ 34.2 12 1

Sort (cost=731.85..732.05 rows=410 width=12) (actual time=0.721..0.722 rows=12 loops=1)

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

Bitmap Heap Scan on building_search_words building_search_words (cost=50.64..728.29 rows=410 width=12) (actual time=0.599..0.711 rows=12 loops=1)

3. 0.534 0.534 ↑ 6.6 62 1

Bitmap Index Scan on building_search_words_idx_word (cost=0.00..50.61 rows=410 width=0) (actual time=0.534..0.534 rows=62 loops=1)

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