Re: Are indexes blown?

On 15/02/2008, Shoaib Mir <shoaibmir@gmail.com> wrote:
>
>
> On Fri, Feb 15, 2008 at 3:55 PM, Phoenix Kiula <phoenix.kiula@gmail.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.



How should I install a "contrib" without bringing down my database, or
stopping it, or doing ANYTHING to it? It's in production. I can't
touch it. Will it be installed on the side and then I simply start
using it?