Re: [PERFORM] Query hangs sometimes

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

Re: [PERFORM] Query hangs sometimes

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,

Re: [PERFORM] Query hangs sometimes

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 ?

[PERFORM] Query hangs sometimes

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