postgresql查看数据库物理大小
1.查看数据库总大小
select pg_size_pretty(pg_database_size('incidentdispatch'));
2.查看数据库oid
SELECT oid from pg_database where datname='incidentdispatch';
3.查看指定模式下每个表的大小
SELECT table_name,
pg_size_pretty(total_bytes) AS total_size
FROM (
SELECT...
docs.inorah.xyz1 min read