I am running query without limit.. it works fine in PGAdmin.
Regards,
Anjul TYAGI
ü Go Green
------ Original Message ------
From: "sunil kumar" <sunildeshalhre92@xxxxxxxxx>
To: "Anjul Tyagi" <anjul@xxxxxxxxxxxxxxxx>
Cc: "pgsql-admin" <pgsql-admin@xxxxxxxxxxxxxx>
Sent: 26-08-2019 18:54:27
Subject: Re: Slow Query
Hi,First of all you need to check you query once. While in PostgreSQL we can only test fewer data than the whole.We always use limit in editor to test query. Its costly when you use select everything from table. Can we see your query and execution plan.On Mon, 26 Aug 2019, 6:11 p.m. Anjul Tyagi, <anjul@xxxxxxxxxxxxxxxx> wrote:Hi Expert,we are having weird issue, i have query that is running fine when i run that in pgadmin. however same query keep running from application. I checked the explain plan and other details and did not found anything.Can you please help me, how can i figure out more to identify the root cause.Regards,
Anjul TYAGI
ü Go Green
