| 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: | Whole Thread | Raw Message | 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? |