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

11 votes154 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
0 vote116 views1 answer
Sql get date from timestamp
SQL
0 vote196 views1 answer
Bigrock database connection string
SQL
0 vote124 views1 answer
Postgresql on conflict pair
SQL
0 vote156 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote142 views2 answers
Amazon linux postgresql client
SQL
0 vote127 views1 answer
Top 3 salary in sql
SQL
1 vote133 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote125 views1 answer
Mysql query single row
SQL
0 vote123 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL