Postgres

Database and table size

Each database size

SELECT pg_database.datname as "database_name",
	pg_database_size(pg_database.datname) AS size,
	pg_size_pretty(pg_database_size(pg_database.datname)) AS size_in_mb
FROM pg_database

Each table size in the DB

SELECT
    relname AS "relation", nspname,
    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 20;

---

Backlinks

• root