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

4 votes322 views2 answers
Oracle sql group by date year
SQL
0 vote335 views1 answer
Not equal to blank in mysql
SQL
0 vote340 views1 answer
How to find table lock and row lock in mysql
SQL
4 votes342 views4 answers
What is primary key
SQL
0 vote305 views1 answer
Recursive query herarchical data sql server
SQL
0 vote330 views1 answer
Create tables from xsd to sql server database c#
SQL
2 votes339 views1 answer
How to delete columns in sql
SQL
0 vote315 views1 answer
Mysql docker image for macbook m1
SQL
0 vote301 views1 answer
Dump only schema
SQL
0 vote297 views1 answer
How to install Firebird
SQL