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 vote300 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote297 views2 answers
Sqlite unix timestamp
SQL
0 vote278 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
10 votes325 views2 answers
Doublon sql
SQL
-1 vote284 views1 answer
Sql getdate date only
SQL
0 vote281 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
5 votes271 views2 answers
Mysql where in array
SQL
0 vote316 views1 answer
How to install postgresql on wsl
SQL
2 votes298 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
1 vote302 views1 answer
Hexadec to sql REDSHIFT
SQL