Here is a SQL shows your postgres instance overall vacuum status

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

 

Output will look like this, it shows each relation's vacuum status in the db

 

relname        | last_autoanalyze    | last_autovacuum     | last_vacuum         | n_dead_tup 
lsfilerequests | 2013-11-05 10:46:34 | 2013-11-05 08:30:41 | 2013-08-07 12:37:25 | 577380