Ron <ronljohnso...@gmail.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.consult...@comcast.net
