Re: Select query taking forever

Поиск
Список
Период
Сортировка
От Julien Rouhaud
Тема Re: Select query taking forever
Дата
Msg-id CAOBaU_ZVsCrp2XsWaLoXO+vCb7ifr2zhxqRhne5u1BvrekhjnA@mail.gmail.com
обсуждение исходный текст
Ответ на Select query taking forever  (Firthouse banu <penguinsfairy@gmail.com>)
Список pgsql-admin
Hi,

On Mon, Aug 17, 2020 at 1:17 PM Firthouse banu <penguinsfairy@gmail.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
columnsfrom all these tables with some conditions . It’s taking forever and in explain plan it is having nested loop
andcost 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.



В списке pgsql-admin по дате отправления:

Предыдущее
От: Firthouse banu
Дата:
Сообщение: Select query taking forever
Следующее
От: dbatoCloud Solution
Дата:
Сообщение: Re: Database Stats getting reset after server restart