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

1 vote157 views1 answer
Snowflake rename column name
SQL
1 vote139 views1 answer
Denied
SQL
0 vote170 views1 answer
Codigo crear tablas sql server
SQL
1 vote196 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote151 views1 answer
What is SQL data store?
SQL
0 vote158 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
2 votes139 views1 answer
When matched in sql server
SQL
0 vote146 views1 answer
Mysql drop multiple tables at once
SQL
3 votes155 views1 answer
Oracle user privileges
SQL
0 vote156 views1 answer
Oracle list partitions
SQL