Created
May 10, 2013 17:15
-
-
Save teburd/5555866 to your computer and use it in GitHub Desktop.
no rank, limit, or order
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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