PostgreSQL_寻找数据库里最大的表
1.查询数据库的大小;
SELECT pg_database_size('PROD_TRACING')
2.数据库里表格按照大小排序
select relname,relpages from pg_class order by relpages DESC;
1.查询数据库的大小;
SELECT pg_database_size('PROD_TRACING')
2.数据库里表格按照大小排序
select relname,relpages from pg_class order by relpages DESC;