Re: Query hangs sometimes

From: Metatrader EA <metatraderea(at)gmail(dot)com>
To: Guillaume Cottenceau <gc(at)mnc(dot)ch>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Query hangs sometimes
Date: 2016-11-17 11:55:11
Message-ID: CAJNXAk2rT6Khk3qk4njv74+ts+zYkf20WUL6CBXZqt8mmaZf6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

How can I check this?

//Bill

On Thu, Nov 17, 2016 at 12:02 PM, Guillaume Cottenceau <gc(at)mnc(dot)ch> 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, '[]') ;
> >
> > Sometimes will query be quick and sometimes is same query SUPER SLOWWWW
> >
> > Something I can do ? Something I can check for ?
> >
> > //Bill
> >
>
> --
> Guillaume Cottenceau
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Seckin Pulatkan 2016-11-17 12:33:06 Re: Query planner chooses index scan backward instead of better index option
Previous Message Guillaume Cottenceau 2016-11-17 11:02:34 Re: Query hangs sometimes