Size of database objects

with tn as (select 'schema.table_name' as table_name)    -- <-- replace 'schema.table_name'
select storage_type
     , pg_size_pretty(storage) as pretty_storage
     , storage
  from (select 'table + TOAST + indexes' as storage_type
             ,  pg_total_relation_size(table_name) as storage
          from tn
        union all
        select 'table + TOAST' as storage_type
             ,  pg_table_size(table_name) as storage
          from tn
        union all
        select 'table' as storage_type
             ,  pg_relation_size(table_name) as storage
          from tn
        union all
        select 'indizes' as storage_type
            ,  pg_indexes_size(table_name) as storage
          from tn
);