Select query taking forever

From: Firthouse banu <penguinsfairy(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Select query taking forever
Date: 2020-08-17 11:17:06
Message-ID: CAK_Ha4w9+Gi7rownhC=V1KVfjA+kaGmuFoX-eyW2f+SnbD4fcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Thanks & regards
Firthouse

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Rouhaud 2020-08-17 11:22:54 Re: Select query taking forever
Previous Message Sujith Kumar.S 2020-08-17 09:52:44 Re: Database Stats getting reset after server restart