Query hangs sometimes

From: Metatrader EA <metatraderea(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Query hangs sometimes
Date: 2016-11-17 10:43:19
Message-ID: CAJNXAk1MDZZ6UYApOPuZ3kYm4wT6=1fyK997onALaca6NHFdNA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Cottenceau 2016-11-17 11:02:34 Re: Query hangs sometimes
Previous Message Metatrader EA 2016-11-16 09:10:36 Run one query and execution time is very different