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 vote132 views1 answer
Inner joint
SQL
0 vote148 views1 answer
Insert into select with group by
SQL
0 vote162 views1 answer
Sql server sleep
SQL
1 vote154 views1 answer
Sql select max value from multiple rows
SQL
0 vote144 views1 answer
Python connect microsoft sql server
SQL
13 votes141 views2 answers
Get tables in database sql
SQL
16 votes147 views2 answers
Oracle ddl
SQL
13 votes135 views5 answers
Oracle list tables
SQL
0 vote167 views1 answer
Mysql preg replace
SQL
0 vote145 views1 answer
Sqlalchemy get ids
SQL