Postgresql – Postgres – how to tell when the last VACUUM FULL was run

postgresql

If I run the following

VACUUM myTable;

this gets recorded in the postgres system tables and can be seen with

select last_vacuum, vacuum_count from pg_stat_all_tables where relname= 'mytable';

However, doing a VACUUM FULL seems to go unrecorded.

How can I tell when the last VACUUM FULL was run against a table?

Best Answer

PostgreSQL doesn't track that information.

Related Question