Postgresql find biggest table

select schemaname as table_schema,
    relname as table_name,
    pg_size_pretty(pg_total_relation_size(relid)) as total_size,
    pg_size_pretty(pg_relation_size(relid)) as data_size,
    pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid))
      as external_size
from pg_catalog.pg_statio_user_tables
order by pg_total_relation_size(relid) desc,
         pg_relation_size(relid) desc
limit 10;

Source: dataedo.com

Similar codes

0 vote339 views1 answer
Compression of dabatase mysqldumo
SQL
3 votes344 views2 answers
How to start postgresql on windows
SQL
0 vote342 views1 answer
Placements hackerrank solution
SQL
0 vote354 views2 answers
Cambiar nombre tabla mysql
SQL
6 votes378 views3 answers
Rename column ORACLE
SQL
-1 vote359 views1 answer
Spring boot mysql connection properties
SQL
0 vote302 views1 answer
How to set field to null in sql
SQL
0 vote359 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote362 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote335 views3 answers
Get count of null in column sql
SQL