Skip to content

Instantly share code, notes, and snippets.

@sargun

sargun/gist:9653900

Created March 19, 2014 23:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sargun/9653900 to your computer and use it in GitHub Desktop.
Save sargun/9653900 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
avocado=# EXPLAIN (ANALYZE TRUE, VERBOSE TRUE) SELECT "templates".id FROM "templates" WHERE (to_tsvector('english', "templates"."source"::text) @@ plainto_tsquery('english', 'dimension'::text));
NOTICE: word is too long to be indexed
DETAIL: Words longer than 2047 characters are ignored.
NOTICE: word is too long to be indexed
DETAIL: Words longer than 2047 characters are ignored.
NOTICE: word is too long to be indexed
DETAIL: Words longer than 2047 characters are ignored.
NOTICE: word is too long to be indexed
DETAIL: Words longer than 2047 characters are ignored.
NOTICE: word is too long to be indexed
DETAIL: Words longer than 2047 characters are ignored.
NOTICE: word is too long to be indexed
DETAIL: Words longer than 2047 characters are ignored.
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------------
Seq Scan on public.templates (cost=0.00..39506.12 rows=15139 width=4) (actual time=1.525..12470.556 rows=14826 loops=1)
Output: id
Filter: (to_tsvector('english'::regconfig, templates.source) @@ '''dimens'''::tsquery)
Rows Removed by Filter: 64659
Total runtime: 12472.592 ms
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment