List the size of all tables in postgresql

list-table-sizes.sql

SELECT
    schemaname,
    tablename,
    PG_SIZE_PRETTY(
        PG_TOTAL_RELATION_SIZE(schemaname || '.' || tablename)
    ) AS tablesize
FROM
    pg_catalog.pg_tables
WHERE
    schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY
    PG_TOTAL_RELATION_SIZE(schemaname || '.' || tablename) DESC;