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

1 vote131 views1 answer
Funzioni plsql
SQL
0 vote143 views1 answer
Get the Db column names from a SqlDataReader
SQL
3 votes147 views1 answer
How to uninstall microsoft sql server
SQL
0 vote164 views1 answer
000webhost database values insert
SQL
11 votes122 views1 answer
Oracle insert into where
SQL
49 votes220 views6 answers
Mysql add column to table
SQL
3 votes131 views3 answers
Mysql select table names
SQL
0 vote139 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
6 votes121 views3 answers
Mysql server is not starting xampp
SQL
1 vote137 views1 answer
How to check the mysql version mac
SQL