Skip to content

Instantly share code, notes, and snippets.

@alekseyl

alekseyl/broken_like_example.sql

Last active November 24, 2017 11:12
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 alekseyl/088c9a712627efb62f0c223901ef1642 to your computer and use it in GitHub Desktop.
Save alekseyl/088c9a712627efb62f0c223901ef1642 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
broken_like_example.sql
EXPLAIN ANALYZE SELECT * FROM words WHERE word LIKE 't%' LIMIT 10;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------
Limit (cost=0.00..32.10 rows=10 width=440) (actual time=68.487..100.961 rows=10 loops=1)
-> Seq Scan on words (cost=0.00..40795.61 rows=12707 width=440) (actual time=68.485..100.959 rows=10 loops=1)
Filter: ((word)::text ~~ 't%'::text)
Rows Removed by Filter: 181269
Planning time: 7.296 ms
Execution time: 101.007 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment