On 15/02/2008, Shoaib Mir <shoaibmir@xxxxxxxxx> wrote: > > > On Fri, Feb 15, 2008 at 3:55 PM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> > 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? ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
