Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Query - Mailing list pgsql-admin

From sunil kumar
Subject Re: Slow Query
Date
Msg-id CA+irN8+MMgfOMFkYqHSw8=ZkYMkDX9Msj08_oQwGQsXUUBCuoA@mail.gmail.com
Whole thread Raw
In response to Slow Query  ("Anjul Tyagi" <anjul@ibosstech-us.com>)
Responses Re: Slow Query  ("Anjul Tyagi" <anjul@ibosstech-us.com>)
List pgsql-admin
Tree view
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@ibosstech-us.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


pgsql-admin by date:

Previous
From: "Anjul Tyagi"
Date:
Subject: Slow Query
Next
From: "Anjul Tyagi"
Date:
Subject: Re: Slow Query