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.