Postgres Pro
Downloads
Home   >   mailing lists

Select query taking forever - Mailing list pgsql-admin

From Firthouse banu
Subject Select query taking forever
Date
Msg-id CAK_Ha4w9+Gi7rownhC=V1KVfjA+kaGmuFoX-eyW2f+SnbD4fcg@mail.gmail.com
Whole thread Raw
Responses Re: Select query taking forever  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-admin
Tree view
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 

pgsql-admin by date:

Previous
From: "Sujith Kumar.S"
Date:
Subject: Re: Database Stats getting reset after server restart
Next
From: Julien Rouhaud
Date:
Subject: Re: Select query taking forever