Statistics tables not being updated anymore

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Statistics tables not being updated anymore
Date: 2019-07-01 17:27:33
Message-ID: 4939085b-d994-4d35-ce15-f14d6257e64a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.

v9.6.9

Statistics views like pg_stat_*_tables, pg_stat_*_indexes,
pg_statio_*_tables and pg_statio_*_indexes aren't being updated anymore.
Specifically, all counter fields are 0, and date fields are blank.

The first thing I checked was postgresql.conf (but it hasn't been modified
since December 2018), and track_activities is turned on. Also, I connect as
user "postgres", so it's not a privileges problem.

Where else should I look?

track_activities                    | on
track_activity_query_size           | 1024
track_commit_timestamp              | off
track_counts                        | on
track_functions                     | none
track_io_timing                     | off

Thanks

--
Angular momentum makes the world go 'round.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-07-01 18:07:13 Re: Statistics tables not being updated anymore
Previous Message Tom Lane 2019-07-01 14:19:39 Re: Use ctid in where clause in update from statement