Re: [PERFORM] Query hangs sometimes

2016-11-17 Thread Michael Paquier
On Thu, Nov 17, 2016 at 3:55 AM, Metatrader EA wrote: > How can I check this? Several options are listed in the docs: https://www.postgresql.org/docs/9.6/static/monitoring.html -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your sub

Re: [PERFORM] Query hangs sometimes

2016-11-17 Thread Metatrader EA
Hi, How can I check this? //Bill On Thu, Nov 17, 2016 at 12:02 PM, Guillaume Cottenceau wrote: > Locks? (VACUUM FULL, etc) Autovacuum? > > > Hi, > > > > I run this query select count(*) from analyse_forecast where > daterange_analyse > > <@ daterange( current_date - 150, current_date, '[]') ;

Re: [PERFORM] Query hangs sometimes

2016-11-17 Thread Guillaume Cottenceau
Locks? (VACUUM FULL, etc) Autovacuum? > Hi, > > I run this query select count(*) from analyse_forecast where > daterange_analyse  > <@ daterange( current_date - 150, current_date, '[]') ; > > Sometimes will query be quick and sometimes is same query SUPER SLO > > Something I can do ? Somethin

[PERFORM] Query hangs sometimes

2016-11-17 Thread Metatrader EA
Hi, I run this query select count(*) from analyse_forecast where daterange_analyse <@ daterange( current_date - 150, current_date, '[]') ; Sometimes will query be quick and sometimes is same query SUPER SLO Something I can do ? Something I can check for ? //Bill

Re: [PERFORM] query hangs

2010-06-14 Thread Scott Marlowe
On Thu, Jun 10, 2010 at 5:36 AM, AI Rumman wrote: > I found only AccessShareLock in pg_locks during the query. > And the query does not return data though I have been waiting for 10 mins. > > Do you have any idea ? I have queries that run for hours. As long as it's using CPU / IO (use top in uni

Re: [PERFORM] query hangs

2010-06-14 Thread Kevin Grittner
AI Rumman wrote: > [It takes a long time to return 2.6 million rows.] > Any more idea, please. I don't recall you telling us exactly what the environment and connection type is in which you're trying to return this large result set. Any specific suggestions would depend on that information.

Re: [PERFORM] query hangs

2010-06-13 Thread AI Rumman
Any more idea, please. Is table partition a good solution for query optimization? On Fri, Jun 11, 2010 at 11:09 AM, Amit Khandekar < amit.khande...@enterprisedb.com> wrote: > > > On 10 June 2010 18:47, AI Rumman wrote: > >> I am using Postgresql 8.1 and did not find FETCH_COUNT >> >> > Oh ok. Lo

Re: [PERFORM] query hangs

2010-06-10 Thread Amit Khandekar
On 10 June 2010 18:47, AI Rumman wrote: > I am using Postgresql 8.1 and did not find FETCH_COUNT > > Oh ok. Looks like FETCH_COUNT was introduced in 8.2 > On Thu, Jun 10, 2010 at 6:55 PM, Amit Khandekar < > amit.khande...@enterprisedb.com> wrote: > >> >> >> On 10 June 2010 18:05, AI Rumman wro

Re: [PERFORM] query hangs

2010-06-10 Thread AI Rumman
I am using Postgresql 8.1 and did not find FETCH_COUNT On Thu, Jun 10, 2010 at 6:55 PM, Amit Khandekar < amit.khande...@enterprisedb.com> wrote: > > > On 10 June 2010 18:05, AI Rumman wrote: > >> Could you please give me the link for cursor- How to use it? >> >> >> On Thu, Jun 10, 2010 at 6:28 P

Re: [PERFORM] query hangs

2010-06-10 Thread Amit Khandekar
On 10 June 2010 18:05, AI Rumman wrote: > Could you please give me the link for cursor- How to use it? > > > On Thu, Jun 10, 2010 at 6:28 PM, Kevin Grittner < > kevin.gritt...@wicourts.gov> wrote: > >> AI Rumman wrote: >> >> >> Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506) >>

Re: [PERFORM] query hangs

2010-06-10 Thread AI Rumman
Could you please give me the link for cursor- How to use it? On Thu, Jun 10, 2010 at 6:28 PM, Kevin Grittner wrote: > AI Rumman wrote: > > >> Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506) > > > And the query does not return data though I have been waiting for > > 10 mins. > >

Re: [PERFORM] query hangs

2010-06-10 Thread Kevin Grittner
AI Rumman wrote: >> Merge Left Join (cost=9500.30..101672.51 rows=2629549 width=506) > And the query does not return data though I have been waiting for > 10 mins. > > Do you have any idea ? Unless you use a cursor, PostgreSQL interfaces typically don't show any response on the client side u

Re: [PERFORM] query hangs

2010-06-10 Thread Szymon Guz
2010/6/10 AI Rumman > I found only AccessShareLock in pg_locks during the query. > And the query does not return data though I have been waiting for 10 mins. > > Do you have any idea ? > > > On Thu, Jun 10, 2010 at 5:26 PM, Szymon Guz wrote: > >> >> >> 2010/6/10 AI Rumman >> >> Can anyone pleas

Re: [PERFORM] query hangs

2010-06-10 Thread AI Rumman
I found only AccessShareLock in pg_locks during the query. And the query does not return data though I have been waiting for 10 mins. Do you have any idea ? On Thu, Jun 10, 2010 at 5:26 PM, Szymon Guz wrote: > > > 2010/6/10 AI Rumman > > Can anyone please tell me why the following query hangs?

Re: [PERFORM] query hangs

2010-06-10 Thread Szymon Guz
2010/6/10 AI Rumman > Can anyone please tell me why the following query hangs? > This is a part of a large query. > > explain > select * > from vtiger_emaildetails > inner join vtiger_vantage_email_track on vtiger_emaildetails.emailid = > vtiger_vantage_email_track.mailid > left join vtiger_seact

[PERFORM] query hangs

2010-06-10 Thread AI Rumman
Can anyone please tell me why the following query hangs? This is a part of a large query. explain select * from vtiger_emaildetails inner join vtiger_vantage_email_track on vtiger_emaildetails.emailid = vtiger_vantage_email_track.mailid left join vtiger_seactivityrel on vtiger_seactivityrel.activi