Re: Why my query not using index to sort?

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Re: Why my query not using index to sort?
Дата
Msg-id 761996F5-EF2E-48C9-A250-B41A63239E01@zeit.io
обсуждение исходный текст
Ответ на Re: Why my query not using index to sort?  (Arup Rakshit <ar@zeit.io>)
Ответы Re: Why my query not using index to sort?
Список pgsql-general
Дерево обсуждения
Forgot to mention in my previous email, it was a quick send click. Sorry for that.

In the gist you need to see all the line with Vessel Load(.. . I load the page multiple times to catch the different times, so you will the line multiple times there in the log file.

Thanks,

Arup Rakshit



On 29-Sep-2018, at 12:40 AM, Arup Rakshit <ar@zeit.io> wrote:

Hi Adrian,

> The application is?

It is Ruby On Rails application

> The log settings are?
> Where is it being printed?

The default application log, the production.log file.

> What is being printed?




Thanks,

Arup Rakshit



On 29-Sep-2018, at 12:28 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

On 9/28/18 11:51 AM, Arup Rakshit wrote:
Yes, I have shown the explain plan output. But in my application log the sql query prints 1.7 to 1.9 ms.

So you have added another layer to the process.

The application is?

The log settings are?

What is being printed?

Where is it being printed?

Thanks,
Arup Rakshit
ar@zeit.io <mailto:ar@zeit.io>



--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Arup Rakshit
Дата:
Сообщение: Re: Why my query not using index to sort?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Why my query not using index to sort?