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 13BB58F6-A4D6-475A-A71A-F6B4CF780644@zeit.io
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Why my query not using index to sort?  (Arup Rakshit <ar@zeit.io>)
List pgsql-general
Tree view
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: Adrian Klaver
Date:
Subject: Re: Why my query not using index to sort?
Next
From: Arup Rakshit
Date:
Subject: Re: Why my query not using index to sort?