Postgres Pro
Downloads
Home   >   mailing lists

last_analyze/last_vacuum not being updated - Mailing list pgsql-hackers

From Peter Eisentraut
Subject last_analyze/last_vacuum not being updated
Date
Msg-id 5575EA23.8000005@gmx.net
Whole thread Raw
Responses Re: last_analyze/last_vacuum not being updated  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: last_analyze/last_vacuum not being updated  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: last_analyze/last_vacuum not being updated  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
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)?

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [CORE] back-branch multixact fixes & 9.5 alpha/beta: schedule
Next
From: Tom Lane
Date:
Subject: Re: [CORE] back-branch multixact fixes & 9.5 alpha/beta: schedule