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 vote204 views1 answer
Sql server Cost Fifo query
SQL
3 votes319 views4 answers
Sql interview questions
SQL
5 votes217 views1 answer
Oracle list functions
SQL
0 vote216 views1 answer
Less than date query sqlachemy
SQL
2 votes211 views3 answers
Sql interview query questions
SQL
0 vote181 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
2 votes198 views1 answer
Pdo mysql insert
SQL
0 vote189 views1 answer
Ffeathers express mysql application users login
SQL
0 vote195 views1 answer
How to check which sp is running in sql server
SQL
-1 vote194 views1 answer
How to switch user in mysql
SQL