PSQL手札

• 查看表数据大小

  
  image.png

select relname, relkind, relpages,pg_size_pretty(pg_relation_size(a.oid)),relowner
from pg_class a
where a.relkind in ('r', 'i')
and reltablespace='0'
 order by a.relpages desc;