index is not using? - Mailing list pgsql-performance

From AI Rumman
Subject index is not using?
Date
Msg-id 2a7905441002082355w72ec4b2br9b406f186d87c12a@mail.gmail.com
Whole thread Raw
Responses Re: index is not using?
List pgsql-performance
I have created a index
create index leadaddress_phone_idx on  leadaddress(regexp_replace((phone)::text, '[^0-9]*'::text, ''::text, 'g'::text));
 
But the index is not using.
 
explain select * from leadaddress where regexp_replace(phone,'[^0-9]*','','g') like '%2159438606';
                                               QUERY PLAN                                              
--------------------------------------------------------------------------------------------------------
 Seq Scan on leadaddress  (cost=100000000.00..100009699.81 rows=1 width=97)
   Filter: (regexp_replace((phone)::text, '[^0-9]*'::text, ''::text, 'g'::text) ~~ '%2159438606'::text)
 
Could anyone please tell me why? I analyzed the table after index creation.

pgsql-performance by date:

Previous
From: david@lang.hm
Date:
Subject: Re: Linux I/O tuning: CFQ vs. deadline
Next
From: Scott Marlowe
Date:
Subject: Re: index is not using?