On Fri, Feb 15, 2008 at 3:55 PM, Phoenix Kiula <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]