Thread: Query hangs sometimes
Hi,
I run this query select count(*) from analyse_forecast where daterange_analyse <@ daterange( current_date - 150, current_date, '[]') ;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
Hi,
How can I check this?On Thu, Nov 17, 2016 at 12:02 PM, Guillaume Cottenceau <gc@mnc.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
On Thu, Nov 17, 2016 at 3:55 AM, Metatrader EA <metatraderea@gmail.com> wrote: > How can I check this? Several options are listed in the docs: https://www.postgresql.org/docs/9.6/static/monitoring.html -- Michael