Answers for "postgres get size of database tables"

SQL
5

how to get the size of the database in postgresql

SELECT pg_size_pretty( pg_database_size('dbname') );
Posted by: Guest on February-09-2021
0

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
Posted by: Guest on April-27-2020

Code answers related to "postgres get size of database tables"

Code answers related to "SQL"

Browse Popular Code Answers by Language