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-29 08:11:24
Message-ID: 00B43AD2-C6BA-4429-A0F2-BA9437CEE240@zeit.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
ar(at)zeit(dot)io

> On 29-Sep-2018, at 2:50 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(at)zeit(dot)io <mailto:ar(at)zeit(dot)io>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2018-09-29 10:25:18 Re: Out of Memory
Previous Message Carl Sverre 2018-09-29 06:35:44 Postgres trigger side-effect is occurring out of order with row-level security select policy