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 vote335 views1 answer
Sql get latest of 2 datetimes
SQL
0 vote343 views1 answer
Min:sec datediff mssql
SQL
0 vote317 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote314 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote351 views1 answer
Add new column in sql with foreign key
SQL
20 votes320 views1 answer
Sql change column types
SQL
3 votes294 views1 answer
Sql several or
SQL
0 vote326 views1 answer
Sql developer search all packages for text
SQL
0 vote314 views1 answer
Running query in redshift
SQL
4 votes359 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL