查询gaussdb数据库表空间大小排名

某平台拉链设置，长时间运行后会给数据库带来冗余数据。以下介绍查询高斯库表空间大小排名的查询语句。

语句

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

结果：

清理

truncate table 表名