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 vote302 views1 answer
Mysql order by where condition sub query
SQL
11 votes312 views1 answer
Mysql text type max length
SQL
2 votes298 views1 answer
Date_format for time sql
SQL
3 votes331 views1 answer
Sql print all names that start with a given letter
SQL
2 votes318 views2 answers
How to check database username and password in postgresql
SQL
0 vote296 views1 answer
Oracle sql generate list of days
SQL
2 votes275 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
5 votes272 views1 answer
Postgres upsert
SQL
0 vote299 views2 answers
Find lowest number in sql
SQL
0 vote397 views1 answer
Restart serial number for postgres
SQL