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

5 votes136 views2 answers
Sql number columns
SQL
0 vote95 views1 answer
Psql not found windows
SQL
1 vote140 views1 answer
Oracle lowercase
SQL
0 vote156 views2 answers
Mysql calcular idade
SQL
0 vote137 views1 answer
Postgresql isnull with max
SQL
0 vote148 views1 answer
How to add timestamp column in mysql
SQL
5 votes166 views3 answers
Show indexes mysql
SQL
17 votes174 views6 answers
Get last record in sql
SQL
0 vote143 views1 answer
Access mysql database docker container shell
SQL
4 votes138 views1 answer
Restart for pg_hba.conf file
SQL