postgres query db size code example

Example 1: show size of all tables postgres

select table_name, pg_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'public'
order by 2

Example 2: find size of all DB's postgres

CopySELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname)/1024/1024 AS size_in_mb FROM pg_database ORDER by size_in_mb DESC;

Tags:

Misc Example

Related