SELECT
    schemaname,
    relname,
    n_dead_tup,
    n_live_tup,
    autovacuum_count,
    last_vacuum,
    last_autovacuum,
    last_autoanalyze,
    last_analyze
FROM
    pg_stat_all_tables
WHERE
    n_live_tup > 0
and schemaname not in ('pg_catalog', 'information_schema', 'partman', 'cron')
and last_vacuum>NOW() - interval '7 days' ;