Re: Slow Query

I am running query without limit.. it works fine in PGAdmin.

Regards,

Anjul TYAGI

ü Go Green

------ Original Message ------
From: "sunil kumar" <sunildeshalhre92(at)gmail(dot)com>
To: "Anjul Tyagi" <anjul(at)ibosstech-us(dot)com>
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
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(at)ibosstech-us(dot)com>
>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
>>
>>