Test2

WITH partitions AS (

    SELECT 

        child.relname AS partition_name

    FROM 

        pg_inherits

    JOIN 

        pg_class AS child ON pg_inherits.inhrelid = child.oid

    JOIN 

        pg_class AS parent ON pg_inherits.inhparent = parent.oid

    WHERE 

        parent.relname = 'your_parent_table_name'  -- Replace with your parent table name

)

SELECT 

    p.partition_name,

    s.n_live_tup AS live_rows,

    s.n_dead_tup AS dead_rows,

    s.seq_scan AS seq_scans,

    s.idx_scan AS idx_scans,

    s.n_tup_ins AS inserts,

    s.n_tup_upd AS updates,

    s.n_tup_del AS deletes,

    s.last_vacuum AS last_vacuum,

    s.last_autovacuum AS last_autovacuum,

    s.last_analyze AS last_analyze,

    s.last_autoanalyze AS last_autoanalyze

FROM 

    partitions p

JOIN 

    pg_stat_user_tables s ON p.partition_name = s.relname;