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 vote115 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote122 views2 answers
Identity syntax in sql
SQL
0 vote121 views1 answer
Sql server user permissions and roles
SQL
0 vote114 views1 answer
Rabbitmq ui not working
SQL
-1 vote120 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote130 views1 answer
T sql dynamic top n query
SQL
3 votes123 views4 answers
Show databases in sql server
SQL
2 votes109 views2 answers
Sql first character
SQL
0 vote219 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
-1 vote112 views1 answer
Module operator in oracle sql
SQL