Как узнать размер таблиц в postgresql

Запрос возвращает размер всех таблиц в базе.



select nspname || '.' || relname as "relation", pg_size_pretty(pg_relation_size(pc.oid)) as "size" from pg_class pc left join pg_namespace n on (n.oid = pc.relnamespace) where nspname not in ('pg_catalog', 'information_schema') order by pg_relation_size(pc.oid) desc;

Запрос возвращает общий размер таблиц, включая все индексы в текущей базе данных:

select nspname || '.' || relname as "relation", pg_size_pretty(pg_total_relation_size(pc.oid)) as "total_size" from pg_class pc left join pg_namespace pn on (pn.oid = pc.relnamespace) where nspname not in ('pg_catalog', 'information_schema') and pc.relkind <> 'i' and nspname !~ '^pg_toast' order by pg_total_relation_size(pc.oid) desc