Postgres Pro
Downloads
Home   >   mailing lists

Re: Why my query not using index to sort? - Mailing list pgsql-general

From Arup Rakshit
Subject Re: Why my query not using index to sort?
Date
Msg-id 761996F5-EF2E-48C9-A250-B41A63239E01@zeit.io
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Arup Rakshit <ar@zeit.io>)
Responses Re: Why my query not using index to sort?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Arup Rakshit
Date:
Subject: Re: Why my query not using index to sort?
Next
From: Adrian Klaver
Date:
Subject: Re: Why my query not using index to sort?