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; relname | totalreads ---------+------------ (0 rows) //Bill
Is statistics collection enabled in the config? See: https://www.postgresql.org/docs/9.5/static/monitoring-stats.html -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance