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.klaver@aklaver.com