Thread: BUG #15319: pg_stat_user_tables not showing last vacuum date
The following bug has been logged on the website: Bug reference: 15319 Logged by: shaurya jain Email address: 12345shaurya@gmail.com PostgreSQL version: 10.3 Operating system: CentOS release 6.5 (Final) Description: last_vacuum column of pg_stat_user_tables is not getting update on vacuum with full.It is working fine on vacuum only.
Hello This is documented behavior: https://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW > last_vacuum timestamp with time zone Last time at which this table was manually vacuumed (not counting VACUUM FULL) So, this is not bug. regards, Sergei
Dear Sergei,
Thanks for your prompt response.Yeah it's clear now.
On Thu, Aug 9, 2018 at 1:37 PM, Sergei Kornilov <sk@zsrv.org> wrote:
Hello
This is documented behavior: https://www.postgresql.org/docs/current/static/ monitoring-stats.html#PG-STAT- ALL-TABLES-VIEW
> last_vacuum timestamp with time zone Last time at which this table was manually vacuumed (not counting VACUUM FULL)
So, this is not bug.
regards, Sergei