varchar_pattern_example4.sql

EXPLAIN ANALYZE SELECT * FROM words WHERE word LIKE 'o%' ORDER BY word LIMIT 10;
                                                                   QUERY PLAN                                                                   
------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=20178.09..20178.12 rows=10 width=440) (actual time=123.264..123.267 rows=10 loops=1)
   ->  Sort  (cost=20178.09..20199.27 rows=8471 width=440) (actual time=123.263..123.264 rows=10 loops=1)
         Sort Key: word
         Sort Method: top-N heapsort  Memory: 29kB
         ->  Bitmap Heap Scan on words  (cost=218.41..19995.04 rows=8471 width=440) (actual time=12.194..97.945 rows=11599 loops=1)
               Filter: ((word)::text ~~ 'o%'::text)
               Heap Blocks: exact=1192
               ->  Bitmap Index Scan on index_words_word  (cost=0.00..216.29 rows=8387 width=0) (actual time=10.560..10.560 rows=11599 loops=1)
                     Index Cond: (((word)::text ~>=~ 'o'::text) AND ((word)::text ~<~ 'p'::text))
 Planning time: 0.335 ms
 Execution time: 123.362 ms