| From: | vinny <vinny(at)xs4all(dot)nl> |
|---|---|
| To: | Metatrader EA <metatraderea(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, pgsql-performance-owner(at)postgresql(dot)org |
| Subject: | Re: DO I miss something ? |
| Date: | 2016-11-18 14:04:46 |
| Message-ID: | 96622dd7e044b70c019de4987a68129d@xs4all.nl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carmen Mardiros | 2016-11-23 22:15:25 | How to tune Postgres to take advantage of 256GB RAM hardware |
| Previous Message | Metatrader EA | 2016-11-18 13:52:54 | DO I miss something ? |