| From: | "Usama Dar" <munir(dot)usama(at)gmail(dot)com> |
|---|---|
| To: | Marc <pgsql-general(at)mbreslow(dot)net> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: slow query |
| Date: | 2007-12-25 16:31:54 |
| Message-ID: | ff0e67090712250831if952969x108a5a5d827d0a06@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Dec 22, 2007 12:10 AM, Marc <pgsql-general(at)mbreslow(dot)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.28rows=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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Usama Dar | 2007-12-25 16:38:18 | Re: Restoring 8.0 db to 8.1 |
| Previous Message | Farhan Mughal | 2007-12-25 15:44:53 | Re: It's serious,Help! |