| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Firthouse banu <penguinsfairy(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Select query taking forever |
| Date: | 2020-08-17 11:22:54 |
| Message-ID: | CAOBaU_ZVsCrp2XsWaLoXO+vCb7ifr2zhxqRhne5u1BvrekhjnA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
On Mon, Aug 17, 2020 at 1:17 PM Firthouse banu <penguinsfairy(at)gmail(dot)com> wrote:
>
> Hi Team,
>
> I have 3 tables one with 84k records , one with 20 records and another one with 1000 records and am fetching few columns from all these tables with some conditions . It’s taking forever and in explain plan it is having nested loop and cost is high. I have created index also for these tables but still it’s taking sequential scan.
>
> Any suggestions
It's impossible to help with that few details. See
https://wiki.postgresql.org/wiki/Slow_Query_Questions for what to
include.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jay Korrapati | 2020-08-18 23:52:10 | Re: Data sync between Oracle Non Cloud and PostgresDb in Azure |
| Previous Message | Firthouse banu | 2020-08-17 11:17:06 | Select query taking forever |