last_analyze/last_vacuum not being updated

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: last_analyze/last_vacuum not being updated
Date: 2015-06-08 19:16:51
Message-ID: 5575EA23.8000005@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm looking at a case on 9.4.1 where the last_analyze and last_vacuum
stats for a handful of tables seem stuck. They don't update after
running an ANALYZE or VACUUM command, and they don't react to
pg_stat_reset_single_table_counters(). All of the affected tables are
system catalogs, some shared, some not. Other system catalogs and other
tables have their statistics updated normally. Any ideas (before I try
to blow it away)?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2015-06-08 19:21:34 Re: [CORE] back-branch multixact fixes & 9.5 alpha/beta: schedule
Previous Message Robert Haas 2015-06-08 19:05:43 Re: [CORE] back-branch multixact fixes & 9.5 alpha/beta: schedule