[PERFORM] DO I miss something ?

2016-11-18 Thread Metatrader EA
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] DO I miss something ?

2016-11-18 Thread vinny
On 2016-11-18 14:52, Metatrader EA wrote: 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;