Answers for "check all table sizes postgres"

SQL
3

postgres check size table

SELECT pg_size_pretty( pg_total_relation_size('tablename') );
Posted by: Guest on June-15-2020
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 "SQL"

Browse Popular Code Answers by Language