postgresql 查看单个表大小
2024-08-29 00:11:15
3中方法,不论什么一个都行
方法一 ,查一个表
select pg_size_pretty(pg_relation_size('table_name'));
方法二 ,查出全部表并按大小排序
SELECT
table_schema || '.' || table_name
AS table_full_name, pg_size_pretty(pg_total_relation_size('"' ||table_schema || '"."' || table_name || '"')) AS size
FROM
information_schema.tables
ORDER BY
pg_total_relation_size('"' || table_schema || '"."' || table_name || '"')
DESC limit 20
方法三,查出全部表按大小排序并分离data与index
SELECT
table_name,
pg_size_pretty(table_size) AS table_size,
pg_size_pretty(indexes_size) AS indexes_size,
pg_size_pretty(total_size) AS total_size
FROM (
SELECT
table_name,
pg_table_size(table_name) AS table_size,
pg_indexes_size(table_name) AS indexes_size,
pg_total_relation_size(table_name) AS total_size
FROM (
SELECT ('"' || table_schema || '"."' || table_name || '"') AS table_name
FROM information_schema.tables
) AS all_tables
ORDER BY total_size DESC
) AS pretty_sizes
最新文章
- 原生JS封装Ajax插件(同域&;&;jsonp跨域)
- order by用法
- Daily Scrum Meeting ——ThirdDay
- SpirentTestcenter测试仪的自动化
- runtime 运行机制
- ubuntu下eclipse遇到The superclass ";javax.servlet.http.HttpServlet"; was not found on the Java Build Path
- checkbox提交多组数据到action
- Super A^B mod C
- 极客教学:如何使用树莓派击落&;劫持无人机
- UIView局部点击(转)
- 测试ODBC与OLE
- qsettings 保存自定义结构体(QVariant与自定义结构体相互转化)
- 【Hibernate步步】--一对一映射双向关联具体解释(两)
- CentOS文件权限管理
- 弱省胡策 Magic
- Unity3D代码动态修改材质球的颜色
- Educational Codeforces Round 53 Editorial
- windows7下解决caffe check failed registry.count(type) == 1(0 vs. 1) unknown layer type问题
- Python常用模块之PIL(手册篇:Image模块)
- ZOJ 3256 Tour in the Castle 插头DP 矩阵乘法