psql -d appdb -c "SELECT relname, n_live_tup, n_dead_tup FROM pg_stat_user_tables ORDER BY n_dead_tup DESC;"

Ranks user tables by dead tuples, the rows awaiting cleanup by autovacuum. A table with a huge dead count is a candidate for manual VACUUM and ANALYZE. Statistics are approximate until refreshed.