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

1 vote249 views1 answer
Mysql dump specific tables
SQL
3 votes262 views2 answers
Truncate all tables
SQL
0 vote271 views1 answer
Watch mysql command line
SQL
2 votes263 views1 answer
Update with join sql server
SQL
10 votes277 views4 answers
Else if mysql
SQL
2 votes248 views1 answer
Create table with primary key
SQL
5 votes254 views1 answer
Sql use database
SQL
0 vote257 views1 answer
Mysql count number of occurrences in a column
SQL
3 votes251 views3 answers
How to add month in update sql
SQL
5 votes244 views2 answers
Oracle show procedures
SQL