Postgresql check total storage

SELECT nspname || '.' || relname AS "relation",
    pg_size_pretty(pg_relation_size(C.oid)) AS "size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  ORDER BY pg_relation_size(C.oid) DESC
  LIMIT 20;

Source: wiki.postgresql.org

Similar codes

0 vote142 views1 answer
How to update sql server version
SQL
0 vote149 views1 answer
Mysql pv progres
SQL
3 votes86 views1 answer
How to get list of synonyms in oracle
SQL
0 vote157 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
2 votes138 views2 answers
Set database timezone mysql
SQL
21 votes136 views6 answers
Docker run mysql
SQL
0 vote189 views1 answer
Oracle temporary table
SQL
2 votes141 views3 answers
Postgresql reset auto increment
SQL
4 votes168 views4 answers
Remove duplicate old value in mysql
SQL
1 vote130 views1 answer
Login to database mysql terminal
SQL