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 vote143 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote150 views1 answer
Postgres clear table
SQL
2 votes117 views1 answer
Oracle sql drop column if exists
SQL
0 vote132 views1 answer
Oracle table privileges
SQL
2 votes146 views1 answer
Sql missing records from another table
SQL
0 vote181 views1 answer
Mysql grant access to one database
SQL
2 votes124 views1 answer
Sql update from different table
SQL
0 vote122 views1 answer
Oracle sql log to console
SQL
0 vote128 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote142 views1 answer
How to get nth number in sql
SQL