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 vote332 views1 answer
Db format in quotation
SQL
0 vote348 views1 answer
Oracle plsql sleep
SQL
7 votes363 views1 answer
Mysql remote connection command line
SQL
-1 vote328 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
1 vote344 views1 answer
Hexadec to sql REDSHIFT
SQL
2 votes347 views3 answers
Row number mssql
SQL
0 vote353 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote352 views1 answer
Mod in sql
SQL
0 vote336 views2 answers
Jsonb
SQL
0 vote332 views1 answer
Sql count total by foreign key
SQL