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 vote202 views1 answer
Exclude last comma separated string mysql
SQL
12 votes198 views2 answers
Insert multiple rows from another table sql
SQL
1 vote220 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote213 views1 answer
See Foreign Key
SQL
6 votes243 views1 answer
Identify primary key in oracle table
SQL
-2 votes206 views1 answer
Use of where in left join in mysql
SQL
0 vote207 views1 answer
SQL Server modify_timestamp trigger
SQL
0 vote256 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote218 views1 answer
How to join result table in mysql
SQL
0 vote192 views1 answer
Mysql isshow
SQL