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 00B43AD2-C6BA-4429-A0F2-BA9437CEE240@zeit.io
Whole thread Raw
In response to Re: Why my query not using index to sort?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hello Adrian,


I used to consider this time as the sql execution time approximately. I’ll do some research and get back to you. Thanks for mentioning it.


Thanks,

Arup Rakshit



On 29-Sep-2018, at 2:50 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:

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@zeit.io <mailto:ar@zeit.io>


--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-general by date:

Previous
From: Carl Sverre
Date:
Subject: Postgres trigger side-effect is occurring out of order with row-levelsecurity select policy
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Out of Memory