Postgres Pro
Downloads
Home   >   mailing lists

Re: Are indexes blown? - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Are indexes blown?
Date
Msg-id bf54be870802150305o111cfd9en9eb9bb1dea33e131@mail.gmail.com
Whole thread Raw
In response to Are indexes blown?  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Responses Re: Are indexes blown?
List pgsql-general
Tree view


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.

--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm[@]fast.fujitsu.com.au

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Are indexes blown?
Next
From: Richard Huxton
Date:
Subject: Re: Are indexes blown?