PGSQL - DBA - Table Analyzed Status

pgsql-dba-table_analyzed_status.sql

WITH cte_analyze_status as (
    SELECT 
         relname as table_name
        ,last_vacuum
        ,last_autovacuum
        ,last_analyze
        ,last_autoanalyze
        ,n_dead_tup
        ,n_live_tup
        ,CASE WHEN n_dead_tup > 0 THEN n_dead_tup::float / n_live_tup::float  ELSE 0.0 END as dead_decimal
    FROM pg_stat_user_tables )

SELECT
     table_name
    ,last_vacuum
    ,last_autovacuum
    ,last_analyze
    ,last_autoanalyze
    ,n_dead_tup
    ,n_live_tup
    ,dead_decimal
    ,round(((a.dead_decimal)*100.0)::numeric, 2) as dead_percent

FROM cte_analyze_status a
WHERE table_name like 'etl_%' or table_name like 'base_%' 
ORDER BY a.table_name;