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>
>
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? |