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

8 votes266 views1 answer
Show mysql user table
SQL
0 vote293 views1 answer
Add new column in sql with foreign key
SQL
0 vote274 views1 answer
Select the date 30 days less that the todays date sql request
SQL
2 votes279 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
10 votes268 views5 answers
Mysql create user
SQL
0 vote265 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote258 views1 answer
Create new schema mysql
SQL
1 vote268 views1 answer
Pagination sql
SQL
1 vote256 views1 answer
Truncate left characters mysql
SQL
0 vote292 views1 answer
Psql check table fields
SQL