BUG #15319: pg_stat_user_tables not showing last vacuum date

Started by PG Bug reporting formover 7 years ago3 messagesbugs

noreply@postgresql.org

over 7 years ago

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.

Sergei Kornilov

sk@zsrv.org

over 7 years ago

In reply to: PG Bug reporting form (#1)

Re: BUG #15319: pg_stat_user_tables not showing last vacuum date

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

shaurya jain

12345shaurya@gmail.com

over 7 years ago

In reply to: Sergei Kornilov (#2)

Re: BUG #15319: pg_stat_user_tables not showing last vacuum date

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:

Show quoted text

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