| 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> |
| Subject: | Re: Slow Query |
| Date: | 2019-08-26 13:24:27 |
| Message-ID: | CA+irN8+MMgfOMFkYqHSw8=ZkYMkDX9Msj08_oQwGQsXUUBCuoA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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*
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anjul Tyagi | 2019-08-26 13:27:11 | Re: Slow Query |
| Previous Message | Anjul Tyagi | 2019-08-26 12:41:15 | Slow Query |