uxdb 优炫数据库怎么根据库名查出这个库下所有表大小啊?

img

如何根据 传入 public 这个 参数, 查出 txt_100row 和 pre 这两个表 大小啊? 麻烦帮帮忙

首先运行下面的语句，然后复制运行结果放新窗口中运行即可：
uxdb=# SELECT CASE
WHEN t.row_total = 1 THEN
'select * from(' || REPLACE(sql_content, ' union all ', ') a order by 2 desc;')
WHEN t.row_total = t.row_seq THEN
REPLACE(sql_content, ' union all ', ') a order by 2 desc;')
WHEN t.row_seq = 1 THEN
'select * from(' || sql_content
ELSE
sql_content
END sql_content
FROM (SELECT COUNT() over() row_total,
row_number() over() row_seq,
'SELECT ''' || quote_ident(tablename) ||
''' 表名, count() 表行数,ux_size_pretty(ux_total_relation_size(''' ||
quote_ident(tablename) || '''::regclass)) 表总大小 from ' || quote_ident(tablename) ||
' union all ' sql_content
FROM ux_tables
WHERE schemaname = 'public') t

img

img