[PERFORM] DO I miss something ?

Hi, Do I miss something? Shouldn't I have some rows from this query ? Why is it empty? SELECT relname, idx_tup_fetch + seq_tup_read as TotalReads from pg_stat_all_tables WHERE idx_tup_fetch + seq_tup_read != 0 order by TotalReads desc LIMIT 10; relname | totalreads -+ (

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, current_date, '[]') ;

[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

[PERFORM] Run one query and execution time is very different

Hi, I run one query and the execution is very different Select messages from mails_hist join mails using (messages) where message_date > '2016-07-19 00:00:00' andmessage_date < '2016-10-17 00:00:00' Group by message; message_date is one timestamp Query gives around 6300