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 vote309 views3 answers
Run sql command line
SQL
0 vote274 views1 answer
Renommer schema sql
SQL
0 vote274 views1 answer
Oracle enable chain
SQL
1 vote280 views1 answer
Apex select list ORA-20999
SQL
3 votes319 views1 answer
Oracle sql commit example
SQL
3 votes268 views2 answers
Mysql add 2 hours
SQL
0 vote282 views2 answers
How to find sql server agent jobs related to a database
SQL
0 vote279 views1 answer
Sqlite select split string
SQL
0 vote289 views1 answer
Sql server datetime
SQL
0 vote300 views2 answers
Mysql set foreign_key_checks=0
SQL