Re: Statistics tables not being updated anymore

On 7/1/19 1:07 PM, Adrian Klaver wrote:
> On 7/1/19 10:27 AM, Ron wrote:
>> 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?
>
> Is it an autovacuum problem?
>
> What happens if you do a manual ANALYZE?

We run manual ANALYZE jobs every day, and still the columns are blank and zero,

>
> What shows up in the pg_stats view?

Only the pg_catalog tables have values in, for example, elem_count_histogram.

>
>>
>> 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.
>
>

--
Angular momentum makes the world go 'round.