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