SELECT relname, pg_size_pretty(pg_relation_size(oid)) AS size
    FROM pg_class
    ORDER BY pg_relation_size(oid) DESC
    LIMIT 10;