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 vote126 views2 answers
Change database postgres
SQL
2 votes122 views2 answers
Postgresql get table names
SQL
49 votes190 views6 answers
Get duplicate records in sql
SQL
8 votes132 views1 answer
Oracle search stored procedures for text
SQL
0 vote115 views1 answer
Sql join on a subquery
SQL
3 votes112 views2 answers
Find the median in sql
SQL
0 vote120 views1 answer
Power bi union columns
SQL
6 votes116 views4 answers
How to remove unique key in mysql
SQL
0 vote132 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote119 views2 answers
Sql server select where date
SQL