Re: Statistics tables not being updated anymore

On 7/1/19 11:24 AM, Ron wrote:
> 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.

Suggestions:

1) For starters I would go back to the source pg_statistic and see if
the values actually change.

2) Make sure that some code is not issuing a SET that is overriding the
postgresql.conf settings. Or that someone has not changed an include file.

3) Look at pg_stat_activity to see if there is actually any activity
recorded.

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com