Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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