[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: Slow Query
From:       sunil kumar <sunildeshalhre92 () gmail ! com>
Date:       2019-08-26 14:25:08
Message-ID: CA+irN8LRE+pCFgKOcViy-Ryd-Q+49_oLeK6FNhb8tdLem-Nb6A () mail ! gmail ! com
[Download RAW message or body]

Ok.. so may i know the caller platform.. and how you are calling the query
whether it is a Funtion or a query only. And which type of conditions you
are applying to return data?

On Mon, 26 Aug 2019, 7:16 p.m. Luca Ferrari, <fluca1978@gmail.com> wrote:

> On Mon, Aug 26, 2019 at 3:27 PM Anjul Tyagi <anjul@ibosstech-us.com>
> wrote:
> >
> > I am running query without limit.. it works fine in PGAdmin.
> >
>
> You haven't specified the execution plan, nor the application technology.
> My 2 cents go to the fact that the application (driver) could be
> allocating resources to handle the query, and that is something that
> costs.
> Are you really sure the query executed by the application is the query
> you are running or is there any ORM behind the scene?
> What about using auto_explain to see what happens?
>
> Luca
>

[Attachment #3 (text/html)]

<div dir="auto">Ok.. so may i know the caller platform.. and how you are calling the \
query whether it is a Funtion or a query only. And which type of conditions you are \
applying to return data?</div><br><div class="gmail_quote"><div dir="ltr">On Mon, 26 \
Aug 2019, 7:16 p.m. Luca Ferrari, &lt;<a \
href="mailto:fluca1978@gmail.com">fluca1978@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">On Mon, Aug 26, 2019 at 3:27 PM \
Anjul Tyagi &lt;<a href="mailto:anjul@ibosstech-us.com" target="_blank" \
rel="noreferrer">anjul@ibosstech-us.com</a>&gt; wrote:<br> &gt;<br>
&gt; I am running query without limit.. it works fine in PGAdmin.<br>
&gt;<br>
<br>
You haven&#39;t specified the execution plan, nor the application technology.<br>
My 2 cents go to the fact that the application (driver) could be<br>
allocating resources to handle the query, and that is something that<br>
costs.<br>
Are you really sure the query executed by the application is the query<br>
you are running or is there any ORM behind the scene?<br>
What about using auto_explain to see what happens?<br>
<br>
Luca<br>
</blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]