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

11 votes174 views1 answer
Creating tables in sql with python
SQL
1 vote188 views1 answer
Sql server insert into temp table
SQL
0 vote184 views1 answer
How to access to mysql without root
SQL
2 votes164 views1 answer
Change primary key sql
SQL
0 vote169 views1 answer
Yesql
SQL
6 votes202 views1 answer
Identify primary key in oracle table
SQL
1 vote149 views4 answers
Sql now
SQL
49 votes251 views6 answers
Get duplicate records in sql
SQL
0 vote165 views1 answer
Java mysql swing example
SQL
0 vote177 views1 answer
Drop column from table if exist on live server mysql
SQL