Re: Are indexes blown?

On Fri, Feb 15, 2008 at 3:55 PM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
wrote:

> Hi,
>
> I have an index on the user_id field in the query below:
>
> myuser=# delete from clients where user_id like '64.22.91.%';
> DELETE 22
> Time: 220324.975 ms
>
> Is there any reason why it's taking 220 seconds to run this simple
> query? There are about 3 million rows in this table.
>
>
Use the *'pgstattuple'* contrib module -->
http://www.postgresql.org/docs/current/static/pgstattuple.html

*pgstatindex* function from the contrib module should be able to help you
there.

--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm[(at)]fast(dot)fujitsu(dot)com(dot)au