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 vote179 views1 answer
Django mssql backend
SQL
0 vote185 views1 answer
Provide hardcoded value in the mysql query
SQL
1 vote173 views1 answer
Mysql pretty date format
SQL
7 votes165 views3 answers
How to check table name in current database sql
SQL
0 vote195 views1 answer
Generate sql from specific migration ef core
SQL
2 votes175 views2 answers
Mysql search for column name in all tables
SQL
5 votes157 views2 answers
Mysql where in array
SQL
23 votes176 views1 answer
How remove column in mysql
SQL
0 vote164 views1 answer
Alter precision
SQL
10 votes177 views4 answers
Drop primary key
SQL