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 votes200 views3 answers
Mysql remove user privileges
SQL
8 votes180 views2 answers
Mysql query dates between two dates
SQL
3 votes199 views2 answers
Search text in all sql server stored procedure
SQL
6 votes183 views1 answer
How to count number of rows in sql
SQL
0 vote183 views1 answer
Oracle synonym procedure
SQL
0 vote189 views1 answer
Resullt all update knex mysql
SQL
8 votes184 views1 answer
Oracle current date plus 1 month
SQL
0 vote279 views1 answer
Compare strings lexicographically in sql
SQL
0 vote186 views1 answer
Restore backup mysql .gz
SQL
0 vote199 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL