Skip to content

Instantly share code, notes, and snippets.

@teburd
Created May 10, 2013 17:15
Show Gist options
  • Save teburd/5555866 to your computer and use it in GitHub Desktop.
Save teburd/5555866 to your computer and use it in GitHub Desktop.
no rank, limit, or order
drake=# explain analyze select id from vertices where name_fts @@ plainto_tsquery('school'::text);
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------
Bitmap Heap Scan on vertices (cost=37.50..4536.36 rows=2258 width=16) (actual time=1.630..4.424 rows=2307 loops=1)
Recheck Cond: (name_fts @@ plainto_tsquery('school'::text))
-> Bitmap Index Scan on vertices_name_fts_gin_idx (cost=0.00..36.94 rows=2258 width=0) (actual time=1.255..1.255 rows=2307 loops=1)
Index Cond: (name_fts @@ plainto_tsquery('school'::text))
Total runtime: 4.803 ms
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment