Re: Are indexes blown?
| От | Shoaib Mir |
|---|---|
| Тема | Re: Are indexes blown? |
| Дата | |
| Msg-id | bf54be870802150305o111cfd9en9eb9bb1dea33e131@mail.gmail.com обсуждение исходный текст |
| Ответ на | Are indexes blown? ("Phoenix Kiula" <phoenix.kiula@gmail.com>) |
| Ответы |
Re: Are indexes blown?
|
| Список | pgsql-general |
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 по дате отправления: