explain.txt

                      QUERY PLAN                                                
                                                       
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------------
 Limit  (cost=8558.43..8558.48 rows=20 width=20)
   ->  Sort  (cost=8558.43..8563.87 rows=2175 width=20)
         Sort Key: (CASE WHEN ((importance = '0'::double precision) OR (importan
ce IS NULL)) THEN ('0.75001'::double precision - ((search_rank)::double precisio
n / '40'::double precision)) ELSE importance END) DESC
         ->  Bitmap Heap Scan on search_name  (cost=44.86..8500.55 rows=2175 wid
th=20)
               Recheck Cond: (name_vector @> '{5639492}'::integer[])
               ->  Bitmap Index Scan on idx_search_name_name_vector  (cost=0.00.
.44.32 rows=2175 width=0)
                     Index Cond: (name_vector @> '{5639492}'::integer[])
(7 rows)