【测试类型：统计函数】【测试版本：2.0.0】

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openGauss：x86+centos
【测试环境】(单机/1主x备x级联备): 1主1备
【被测功能】: 统计信息函数，统计执行结果
【测试类型】: 功能测试
【数据库版本】(查询命令: gaussdb –V):
gaussdb (openGauss 2.1.0 build da72ef3c) compiled at 2021-09-27 20:24:34 commit 0 last mr
【预置条件】:数据正常

【操作步骤】(请填写详细的操作步骤):
2.1.0版本以下统计函数与2.0.0版本统计结果均不一致：
pg_stat_get_db_blocks_hit
pg_stat_get_dead_tuples
pg_stat_get_function_calls
pg_stat_get_function_total_time
pg_stat_get_tuples_changed
pg_stat_get_tuples_inserted
pg_stat_get_tuples_updated
pg_stat_get_db_xact_commit
pg_indexes_size
已 pg_stat_get_dead_tuples 为例
1.测试用例
--记录的是更新和删除的行数
alter system set autovacuum to off;
SELECT pg_sleep(10);
drop table if exists sales;
select pg_stat_reset();
SELECT pg_sleep(10);
--创建表sales
CREATE TABLE sales
(prod_id NUMBER(6),
cust_id NUMBER,
time_id DATE,
channel_id CHAR(1),
promo_id NUMBER(6),
quantity_sold NUMBER(3),
amount_sold NUMBER(10,2)
);
-- 无数据查询
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
-- 数据插入sales
INSERT INTO sales VALUES(1, 12, '2019-01-10 00:00:00', 'a', 1, 1, 1);
INSERT INTO sales VALUES(1, 12, '2019-02-01 00:00:00', 'b', 1, 1, 1);
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
-- 更新一行数据,旧的其实还在，只是指针指向了新数据，因此dead记录1
update sales set time_id = '2019-06-02 10:00:00' where channel_id = 'b';
SELECT pg_sleep(10);
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
-- 再添加数据 1
INSERT INTO sales VALUES(1, 12, '2019-02-05 00:00:00', 'c', 1, 1, 1);
INSERT INTO sales VALUES(1, 12, '2019-02-03 00:00:00', 'd', 1, 1, 1);
INSERT INTO sales VALUES(1, 12, '2019-02-05 00:00:00', 'e', 1, 1, 1);
SELECT pg_sleep(10);
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
-- 更新多行 4
update sales set time_id = '2015-06-02 10:00:00' where channel_id = 'c';
update sales set time_id = '2013-06-02 10:00:00' where channel_id = 'd';
update sales set time_id = '2012-06-02 10:00:00' where channel_id = 'e';
SELECT pg_sleep(10);
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
-- 删除一行 5
delete from sales where channel_id = 'b';
SELECT pg_sleep(10);
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
-- 删除多行 8
delete from sales where channel_id = 'c';
delete from sales where channel_id = 'd';
delete from sales where channel_id = 'e';
SELECT pg_sleep(10);
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
drop table sales cascade;
alter system set autovacuum to on;
【实际输出】
--记录的是更新和删除的行数
alter system set autovacuum to off;
SQL SUCCESS
SELECT pg_sleep(10);
+----------+
| pg_sleep |
+----------+
| |
+----------+
drop table if exists sales;
SQL SUCCESS
select pg_stat_reset();
+---------------+
| pg_stat_reset |
+---------------+
| |
+---------------+
SELECT pg_sleep(10);
+----------+
| pg_sleep |
+----------+
| |
+----------+
--创建表sales
CREATE TABLE sales
(prod_id NUMBER(6),
cust_id NUMBER,
time_id DATE,
channel_id CHAR(1),
promo_id NUMBER(6),
quantity_sold NUMBER(3),
amount_sold NUMBER(10,2)
);
SQL SUCCESS
-- 无数据查询
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
+-------------------------+
| pg_stat_get_dead_tuples |
+-------------------------+
| 0 |
+-------------------------+
-- 数据插入sales
INSERT INTO sales VALUES(1, 12, '2019-01-10 00:00:00', 'a', 1, 1, 1);
SQL SUCCESS
INSERT INTO sales VALUES(1, 12, '2019-02-01 00:00:00', 'b', 1, 1, 1);
SQL SUCCESS
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
+-------------------------+
| pg_stat_get_dead_tuples |
+-------------------------+
| 0 |
+-------------------------+
-- 更新一行数据,旧的其实还在，只是指针指向了新数据，因此dead记录1
update sales set time_id = '2019-06-02 10:00:00' where channel_id = 'b';
SQL SUCCESS
SELECT pg_sleep(10);
+----------+
| pg_sleep |
+----------+
| |
+----------+
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
+-------------------------+
| pg_stat_get_dead_tuples |
+-------------------------+
| 1 |
+-------------------------+
-- 再添加数据 1
INSERT INTO sales VALUES(1, 12, '2019-02-05 00:00:00', 'c', 1, 1, 1);
SQL SUCCESS
INSERT INTO sales VALUES(1, 12, '2019-02-03 00:00:00', 'd', 1, 1, 1);
SQL SUCCESS
INSERT INTO sales VALUES(1, 12, '2019-02-05 00:00:00', 'e', 1, 1, 1);
SQL SUCCESS
SELECT pg_sleep(10);
+----------+
| pg_sleep |
+----------+
| |
+----------+
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
+-------------------------+
| pg_stat_get_dead_tuples |
+-------------------------+
| 1 |
+-------------------------+
-- 更新多行 4
update sales set time_id = '2015-06-02 10:00:00' where channel_id = 'c';
SQL SUCCESS
update sales set time_id = '2013-06-02 10:00:00' where channel_id = 'd';
SQL SUCCESS
update sales set time_id = '2012-06-02 10:00:00' where channel_id = 'e';
SQL SUCCESS
SELECT pg_sleep(10);
+----------+
| pg_sleep |
+----------+
| |
+----------+
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
+-------------------------+
| pg_stat_get_dead_tuples |
+-------------------------+
| 4 |
+-------------------------+
-- 删除一行 5
delete from sales where channel_id = 'b';
SQL SUCCESS
SELECT pg_sleep(10);
+----------+
| pg_sleep |
+----------+
| |
+----------+
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
+-------------------------+
| pg_stat_get_dead_tuples |
+-------------------------+
| 4 | -------此处统计结果有误
+-------------------------+
-- 删除多行 8
delete from sales where channel_id = 'c';
SQL SUCCESS
delete from sales where channel_id = 'd';
SQL SUCCESS
delete from sales where channel_id = 'e';
SQL SUCCESS
SELECT pg_sleep(10);
+----------+
| pg_sleep |
+----------+
| |
+----------+
select pg_stat_get_dead_tuples(a.oid) from PG_CLASS a where a.relname = 'sales';
+-------------------------+
| pg_stat_get_dead_tuples |
+-------------------------+
| 8 |
+-------------------------+
drop table sales cascade;
SQL SUCCESS
alter system set autovacuum to on;
SQL SUCCESS
【原因分析】: 暂无
【日志信息】(请附上日志文件、截图、coredump信息):