Skip to content

Instantly share code, notes, and snippets.

@sargun

sargun/gist:9653885

Created March 19, 2014 23:31
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/9653885 to your computer and use it in GitHub Desktop.
Save sargun/9653885 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
avocado=# EXPLAIN ANALYZE 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 templates (cost=0.00..39506.12 rows=15139 width=4) (actual time=1.562..12489.234 rows=14825 loops=1)
Filter: (to_tsvector('english'::regconfig, source) @@ '''dimens'''::tsquery)
Rows Removed by Filter: 64660
Total runtime: 12491.200 ms
(4 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment