How to check size of table in postgresql?-CodePudding

i have 1 postgresql database. But I don't know which table is taking up the most space? Is there any way to help me see the capacity of each table in the database?

CodePudding user response：

You can view the top 5 tables with the highest capacity with command:

SELECT
    relname AS "relation",
    pg_size_pretty (
        pg_total_relation_size (C .oid)
    ) AS "total_size"
FROM
    pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace)
WHERE
    nspname NOT IN (
        'pg_catalog',
        'information_schema'
    )
AND C .relkind <> 'i'
AND nspname !~ '^pg_toast'
ORDER BY
    pg_total_relation_size (C .oid) DESC
LIMIT 5;