Statistics tables not being updated anymore - Mailing list pgsql-general

From Ron
Subject Statistics tables not being updated anymore
Date
Msg-id 4939085b-d994-4d35-ce15-f14d6257e64a@gmail.com
Whole thread Raw
Responses Re: Statistics tables not being updated anymore  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Statistics tables not being updated anymore  (Jerry Sievers <gsievers19@comcast.net>)
Re: Statistics tables not being updated anymore  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Statistics tables not being updated anymore  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Statistics tables not being updated anymore  (Adrien Nayrat <adrien.nayrat@anayrat.info>)
List pgsql-general
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?

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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Use ctid in where clause in update from statement
Next
From: Adrian Klaver
Date:
Subject: Re: Statistics tables not being updated anymore