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?