How to check all table size in postgresql - 在PostgreSQL 如何查詢資料庫所有Table的大小

SELECT 
  "table_name",
  pg_size_pretty(pg_total_relation_size(quote_ident("table_name"))),
  pg_total_relation_size(quote_ident("table_name"))
FROM information_schema.tables
WHERE table_schema = 'public'
ORDER BY 3 DESC;