Postgresql

 SELECT ns.nspname AS schema,
    t.relname AS tablename,
    t.reltuples AS num_rows,
    pg_size_pretty(pg_total_relation_size(t.oid::regclass)) AS table_size,
    ts.spcname AS table_tablespace,
    i.indexname,
    pg_size_pretty(pg_total_relation_size(i.oid::regclass)) AS index_size,
    i."unique",
    i.number_of_scans,
    i.tuples_read,
    i.tuples_fetched,
    i.index_tablespace
   FROM pg_class t
     LEFT JOIN ( SELECT ts_1.oid,
            ts_1.spcname
           FROM pg_tablespace ts_1) ts ON t.reltablespace = ts.oid
     JOIN pg_namespace ns ON t.relnamespace = ns.oid
     LEFT JOIN ( SELECT c.oid,
            x.indrelid,
            c.relname AS indexname,
                CASE
                    WHEN x.indisunique THEN 'Y'::text
                    ELSE 'N'::text
                END AS "unique",
            psai.idx_scan AS number_of_scans,
            psai.idx_tup_read AS tuples_read,
            psai.idx_tup_fetch AS tuples_fetched,
            ts_1.spcname AS index_tablespace
           FROM pg_class c
             LEFT JOIN pg_tablespace ts_1 ON c.reltablespace = ts_1.oid,
            pg_index x,
            pg_stat_all_indexes psai
          WHERE c.oid = x.indexrelid AND c.relkind = 'i'::"char" AND x.indexrelid = psai.indexrelid) i ON t.oid = i.indrelid
  WHERE t.relkind = 'r'::"char"
  ORDER BY (pg_total_relation_size(t.oid::regclass)) DESC, ns.nspname, t.relname;

CREATE EXTENSION pgstattuple;

select nspname,
relname,
pg_size_pretty(relation_size + toast_relation_size) as total_size,
pg_size_pretty(toast_relation_size) as toast_size,
round(((relation_size - (relation_size - free_space)*100/fillfactor)*100/greatest(relation_size, 1))::numeric, 1) table_waste_percent,
pg_size_pretty((relation_size - (relation_size - free_space)*100/fillfactor)::bigint) table_waste,
round(((toast_free_space + relation_size - (relation_size - free_space)*100/fillfactor)*100/greatest(relation_size + toast_relation_size, 1))::numeric, 1) total_waste_percent,
pg_size_pretty((toast_free_space + relation_size - (relation_size - free_space)*100/fillfactor)::bigint) total_waste
from (
    select nspname, relname,
    (select free_space from pgstattuple(c.oid)) as free_space,
    pg_relation_size(c.oid) as relation_size,
    (case when reltoastrelid = 0 then 0 else (select free_space from pgstattuple(c.reltoastrelid)) end) as toast_free_space,
    coalesce(pg_relation_size(c.reltoastrelid), 0) as toast_relation_size,
    coalesce((SELECT (regexp_matches(reloptions::text, E'.*fillfactor=(\\d+).*'))[1]),'100')::real AS fillfactor
    from pg_class c
    left join pg_namespace n on (n.oid = c.relnamespace)
    where nspname not in ('pg_catalog', 'information_schema')
    and nspname !~ '^pg_toast' and relkind = 'r'
    --put your table name/mask here
    and relname ~ ''
) t
order by (toast_free_space + relation_size - (relation_size - free_space)*100/fillfactor) desc
limit 20;