explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1OFw

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,231.566 ↑ 1.0 2 1

Unique (cost=13,577.58..13,577.58 rows=2 width=32) (actual time=1,231.565..1,231.566 rows=2 loops=1)

2. 0.024 1,231.564 ↑ 1.0 2 1

Sort (cost=13,577.58..13,577.58 rows=2 width=32) (actual time=1,231.564..1,231.564 rows=2 loops=1)

  • Sort Key: "*SELECT* 1".word
  • Sort Method: quicksort Memory: 25kB
3. 0.002 1,231.540 ↑ 1.0 2 1

Append (cost=6,788.78..13,577.58 rows=2 width=32) (actual time=639.255..1,231.540 rows=2 loops=1)

4. 0.002 639.258 ↑ 1.0 1 1

Subquery Scan on *SELECT* 1 (cost=6,788.78..6,788.79 rows=1 width=8) (actual time=639.255..639.258 rows=1 loops=1)

5. 0.003 639.256 ↑ 1.0 1 1

Limit (cost=6,788.78..6,788.78 rows=1 width=16) (actual time=639.254..639.256 rows=1 loops=1)

6. 0.046 639.253 ↑ 136,556.0 1 1

Sort (cost=6,788.78..6,857.06 rows=136,556 width=16) (actual time=639.252..639.253 rows=1 loops=1)

  • Sort Key: (CASE WHEN (building_search_words.word = 'hudsonweg'::text) THEN 1 ELSE 2 END), ((building_search_words.word OPERATOR(extensions.<->) 'hudsonweg'::text)), building_search_words.word
  • Sort Method: top-N heapsort Memory: 25kB
7. 639.207 639.207 ↑ 11,379.7 12 1

Seq Scan on building_search_words building_search_words (cost=0.00..6,652.23 rows=136,556 width=16) (actual time=41.382..639.207 rows=12 loops=1)

  • Filter: (extensions.similarity(building_search_words.word, 'hudsonweg'::text) > '0.3'::double precision)
8. 0.002 592.280 ↑ 1.0 1 1

Subquery Scan on *SELECT* 2 (cost=6,788.78..6,788.79 rows=1 width=8) (actual time=592.278..592.280 rows=1 loops=1)

9. 0.002 592.278 ↑ 1.0 1 1

Limit (cost=6,788.78..6,788.78 rows=1 width=16) (actual time=592.277..592.278 rows=1 loops=1)

10. 0.036 592.276 ↑ 136,556.0 1 1

Sort (cost=6,788.78..6,857.06 rows=136,556 width=16) (actual time=592.276..592.276 rows=1 loops=1)

  • Sort Key: (CASE WHEN (building_search_words_1.word = 'dlarjff'::text) THEN 1 ELSE 2 END), ((building_search_words_1.word OPERATOR(extensions.<->) 'dlarjff'::text)), building_search_words_1.word
  • Sort Method: quicksort Memory: 25kB
11. 592.240 592.240 ↑ 136,556.0 1 1

Seq Scan on building_search_words building_search_words_1 (cost=0.00..6,652.23 rows=136,556 width=16) (actual time=326.459..592.240 rows=1 loops=1)

  • Filter: (extensions.similarity(building_search_words_1.word, 'dlarjff'::text) > '0.3'::double precision)