kingbaseES基础 sys_total_relation_size 查看表的总大小

原创云散月明 All China Database Union 2022-07-11

1049

Server：CentOS 7.2.1511
KingbaseES：V8R6C5B23

sys_total_relation_size 查看表的总大小

test=# select c1 as other_name from t1;
 other_name 
------------
          0
          1
(2 行记录)

test=# select sys_relation_size('t1');                 
 sys_relation_size 
-------------------
              8192
(1 行记录)

test=# select sys_total_relation_size('t1');
 sys_total_relation_size 
-------------------------
                    8192
(1 行记录)

test=# create index index_c1 on t1(c1);      
CREATE INDEX

test=# select sys_total_relation_size('t1');
 sys_total_relation_size 
-------------------------
                   24576
(1 行记录)

test=# select sys_size_pretty(sys_total_relation_size('t1'));
 sys_size_pretty 
-----------------
 24 kB
(1 行记录)

test=# select sys_relation_size('t1');                       
 sys_relation_size 
-------------------
              8192
(1 行记录)