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.
--
Shoaib Mir
Fujitsu Australia Software Technology
shoaibm[@]fast.fujitsu.com.au
