Re: Slow Query

Поиск
Список
Период
Сортировка
От sunil kumar
Тема Re: Slow Query
Дата
Msg-id CA+irN8+MMgfOMFkYqHSw8=ZkYMkDX9Msj08_oQwGQsXUUBCuoA@mail.gmail.com
обсуждение исходный текст
Ответ на Slow Query  ("Anjul Tyagi" <anjul@ibosstech-us.com>)
Ответы Re: Slow Query
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: "Anjul Tyagi"
Дата:
Сообщение: Slow Query
Следующее
От: "Anjul Tyagi"
Дата:
Сообщение: Re: Slow Query