fastest

gistfile1.txt

                                                                         QUERY PLAN                                                                         
------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=76.15..211.92 rows=100 width=16) (actual time=3.487..3.673 rows=100 loops=1)
   ->  Bitmap Heap Scan on vertices  (cost=76.15..6164.12 rows=4484 width=16) (actual time=3.485..3.641 rows=100 loops=1)
         Recheck Cond: ((name_fts @@ plainto_tsquery('school'::text)) OR (description_fts @@ plainto_tsquery('school'::text)))
         ->  BitmapOr  (cost=76.15..76.15 rows=4521 width=0) (actual time=2.886..2.886 rows=0 loops=1)
               ->  Bitmap Index Scan on vertices_name_fts_gin_idx  (cost=0.00..36.94 rows=2258 width=0) (actual time=1.461..1.461 rows=2307 loops=1)
                     Index Cond: (name_fts @@ plainto_tsquery('school'::text))
               ->  Bitmap Index Scan on vertices_description_fts_gin_idx  (cost=0.00..36.97 rows=2263 width=0) (actual time=1.423..1.423 rows=2255 loops=1)
                     Index Cond: (description_fts @@ plainto_tsquery('school'::text))
 Total runtime: 3.755 ms
(9 rows)