postgres stats

stats.sql

SELECT
    relname AS "relation",
    C .reltuples::bigint AS approximate_rows,
    pg_size_pretty (
            pg_total_relation_size (C .oid)
        ) AS "data_size",
    pg_size_pretty (
        pg_indexes_size(C .oid)
    )  as "indexes_size",
    pg_size_pretty (
            pg_total_relation_size (C .oid) + pg_indexes_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;