Re: Slow Query
"Anjul Tyagi" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.admin |
|---|---|
| Message-ID | <em48a8b4d5-850f-4e66-9839-ddf51c08333b@iboss01081> |
I am running query without limit.. it works fine in PGAdmin. Regards, Anjul TYAGI ü Go Green ------ Original Message ------ From: "sunil kumar" <[email protected]> To: "Anjul Tyagi" <[email protected]> Cc: "pgsql-admin" <[email protected]> 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, <[email protected]> >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 >> >>