# select relname, last_autoanalyze, last_autovacuum, last_vacuum, n_dead_tup
from pg_stat_all_tables where n_dead_tup >0;

Output:

> select relname, last_autoanalyze, last_autovacuum, last_vacuum, n_dead_tup
> from pg_stat_all_tables where n_dead_tup >0;
relname | last_autoanalyze | last_autovacuum | last_vacuum | n_dead_tup
---------+------------------+-----------------+-------------+------------
pg_index | | | | 22
pg_class | | | | 171
pg_attribute | | | | 1337
pg_statistic | | | | 310
pg_depend | | | | 245
pg_type | | | | 185

 

As you can see, theses tables has no vacuum info yet. Just upgraded from pg9.3 to pg9.4, want to check 9.3 or early version vacuum status ? see

Check Postgres vacuum status