[TLM] Re: slow query - Mailing list pgsql-general

From Usama Dar
Subject [TLM] Re: slow query
Date
Msg-id 20071225163555.BEFCD414297@qatlm3.calidad2.pandasoftware.com
Whole thread Raw
In response to slow query  (Marc <pgsql-general@mbreslow.net>)
List pgsql-general


On Dec 22, 2007 12:10 AM, Marc <pgsql-general@mbreslow.net> wrote:
Hey Folks,

This query is running really slowly.  Sometimes much slower then others.  I have a feeling that there may be contention on one of the indices it is using.

Query and explain plan are below.  Seems like it spend the most time doing
Index Scan using i_tablea_atextfield on tablea ru  (cost=0.00..2265.28 rows=2 width=12) (actual time=0.624..881.313 rows=228 loops=1)

Any suggestions?


Just a quick question, when were the tables vacuum analyzed last?



--
Usama Munir Dar http://www.linkedin.com/in/usamadar
Consultant Architect
Cell:+92 321 5020666
Skype: usamadar

pgsql-general by date:

Previous
From: "Josh Harrison"
Date:
Subject: Any big slony and WAL shipping users?
Next
From: Greg Smith
Date:
Subject: [TLM] Re: How to insert on duplicate key?