Re: Why my query not using index to sort?

From: Arup Rakshit <ar(at)zeit(dot)io>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Why my query not using index to sort?
Date: 2018-09-28 19:14:02
Message-ID: 761996F5-EF2E-48C9-A250-B41A63239E01@zeit.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
ar(at)zeit(dot)io

> On 29-Sep-2018, at 12:40 AM, Arup Rakshit <ar(at)zeit(dot)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?
>
> Check the gist: https://gist.github.com/aruprakshit/a6bd7ca221c9a13cd583e0827aa24ad6 <https://gist.github.com/aruprakshit/a6bd7ca221c9a13cd583e0827aa24ad6>
>
>
>
> Thanks,
>
> Arup Rakshit
> ar(at)zeit(dot)io <mailto:ar(at)zeit(dot)io>
>
>
>
>> On 29-Sep-2018, at 12:28 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(at)zeit(dot)io <mailto:ar(at)zeit(dot)io> <mailto:ar(at)zeit(dot)io <mailto:ar(at)zeit(dot)io>>
>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-09-28 21:20:18 Re: Why my query not using index to sort?
Previous Message Arup Rakshit 2018-09-28 19:10:17 Re: Why my query not using index to sort?