Re: Why my query not using index to sort?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Arup Rakshit <ar(at)zeit(dot)io>
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 21:20:18
Message-ID: f0d3bd39-f40b-c3da-8ce3-bd060e46c366@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/28/18 12:14 PM, Arup Rakshit wrote:
> 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.

Do you know what Vessel Load () is actually measuring?

To me it looks like it is covering both the query(including ROR
overhead) and the HTTP request/response cycle.

Also have you looked at:

https://guides.rubyonrails.org/debugging_rails_applications.html#impact-of-logs-on-performance

>
> Thanks,
>
> Arup Rakshit
> ar(at)zeit(dot)io <mailto:ar(at)zeit(dot)io>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message marcelo 2018-09-28 22:49:57 ORM
Previous Message Arup Rakshit 2018-09-28 19:14:02 Re: Why my query not using index to sort?