Обсуждение: Query hangs sometimes

Поиск
Список
Период
Сортировка

Query hangs sometimes

От
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 SLOWWWW

Something I can do ? Something I can check for ?

//Bill

Re: Query hangs sometimes

От
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 SLOWWWW
>
> Something I can do ? Something I can check for ?
>
> //Bill
>

--
Guillaume Cottenceau

Re: Query hangs sometimes

От
Metatrader EA
Дата:
Hi,

How can I check this?

//Bill

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

Re: Query hangs sometimes

От
Michael Paquier
Дата:
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