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 vote122 views1 answer
Mysql conf.d exampel
SQL
1 vote126 views1 answer
Sqlite update from another table
SQL
0 vote109 views1 answer
Mysql installer no packages found
SQL
5 votes112 views2 answers
Sql constraint check value in list
SQL
2 votes111 views1 answer
Copy all values of a column to another column in sql in same table
SQL
2 votes119 views1 answer
Dbms transaction (psql)
SQL
0 vote108 views2 answers
Mysql to python pandas
SQL
-1 vote64 views1 answer
Oracle db list usernames
SQL
6 votes1.2K views1 answer
Sql select second max
SQL
3 votes116 views3 answers
Start postgresql ubuntu
SQL