Postgres Pro
Downloads
Home   >   mailing lists

pg_stat_get_last_vacuum_time(): why non-FULL? - Mailing list pgsql-general

From CR Lender
Subject pg_stat_get_last_vacuum_time(): why non-FULL?
Date
Msg-id 5150DAE2.4040007@gmail.com
Whole thread Raw
Responses Re: pg_stat_get_last_vacuum_time(): why non-FULL?
List pgsql-general
Tree view 
According to the manual (9.1), pg_stat_get_last_vacuum_time() returns

    timestamptz | Time of the last non-FULL vacuum initiated by the
                | user on this table

Why are full vacuums excluded from this statistic? It looks like there's
no way to get the date of the last manual vacuum, if only full vacuums
are performed.


regards,
crl

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: PostgreSQL and VIEWS
Next
From: jayaram s
Date:
Subject: help me to clear postgres problem