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

6 votes115 views3 answers
Date_trunc postgres
SQL
0 vote110 views1 answer
How to get specific salary in sql
SQL
7 votes109 views1 answer
Buy forge mods server hosting
SQL
1 vote113 views1 answer
Flask sqlalchemy default value
SQL
0 vote99 views1 answer
Mysql select last 15 minutes
SQL
3 votes107 views2 answers
Sqlite show table definition
SQL
0 vote113 views1 answer
Insert using condition postgres
SQL
10 votes123 views1 answer
Oracle all_dependencies
SQL
0 vote110 views1 answer
Porcentaje sql
SQL
0 vote110 views1 answer
Mysql changer nom table
SQL