PostGIS中空间数据量查看

whlysu

于 2025-03-07 11:46:27 发布

阅读量70

点赞数 2

文章标签：数据库 postgresql

本文链接：https://blog.youkuaiyun.com/whlysu/article/details/146091843

版权

查看单张表的大小：

SELECT pg_size_pretty(pg_total_relation_size('public.layer_000000_20400000000_jsp'));

查询所有表的大小

SELECT 
    f_table_schema || '.' || f_table_name AS table_name,
    pg_size_pretty(pg_total_relation_size(f_table_schema || '.' || f_table_name)) AS total_size
FROM geometry_columns
ORDER BY pg_total_relation_size(f_table_schema || '.' || f_table_name) DESC;

查询所有表的总和

SELECT pg_size_pretty(SUM(pg_total_relation_size(f_table_schema || '.' || f_table_name))) AS total_size
FROM geometry_columns;