Statistics tables not being updated anymore

Поиск
Список
Период
Сортировка
От Ron
Тема Statistics tables not being updated anymore
Дата
Msg-id 4939085b-d994-4d35-ce15-f14d6257e64a@gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Use ctid in where clause in update from statement
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Statistics tables not being updated anymore