Re: Statistics tables not being updated anymore

Ron <ronljohnsonjr(at)gmail(dot)com> writes:

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

Perhaps your stats collector is dead, blocked or dropping packets.

Check your server logs for anything related.

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

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net