On 7/1/19 1:38 PM, Ron wrote:
On 7/1/19 2:43 PM, Adrian Klaver wrote:
On 7/1/19 12:30 PM, Ron wrote:
On 7/1/19 1:48 PM, Tom Lane wrote:
Ron <ronljohnsonjr@xxxxxxxxx> writes:
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.
Does anything show up in the postmaster log when you try to query
one of those views?
No.
Have you gone through the logs looking for errors/warnings about the
stats collector?
Yes, but there's nothing.
And ps ax | grep postgres shows?:
postgres: stats collector process
If so then I guess you are down to the suggestions upstream that
something is stuck in the stats collectors craw.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
