
create table tbl_1(id int,name varchar(10));
insert into tbl_1 values(1,'a'),(2,'b'),(3,'c'),(4,'d');
(postgres@[local]:5432)-[agedb]-#select * from tbl_1;
id | name
----+------
1 | a
2 | b
3 | c
4 | d
-----------插入4条数据
(postgres@[local]:5432)-[agedb]-#select relname,relpages,reltuples,pg_stat_get_live_tuples(oid),pg_stat_get_dead_tuples(oid) from pg_class where relname = 'tbl_1';
relname | relpages | reltuples | pg_stat_get_live_tuples | pg_stat_get_dead_tuples
---------+----------+-----------+-------------------------+-------------------------
tbl_1 | 1 | 4 | 0 | 0
(1 row)
(postgres@[local]:5432)-[agedb]-#analyze tbl_1 ;
ANALYZE
(postgres@[local]:5432)-[agedb]-#analyze tbl_1 ;
ANALYZE
(postgres@[local]:5432)-[agedb]-#analyze tbl_1 ;
ANALYZE
(postgres@[local]:5432)-[agedb]-#analyze tbl_1 ;
ANALYZE
(postgres@[local]:5432)-[agedb]-#select relname,relpages,reltuples,pg_stat_get_live_tuples(oid),pg_stat_get_dead_tuples(oid) from pg_class where relname = 'tbl_1';
relname | relpages | reltuples | pg_stat_get_live_tuples | pg_stat_get_dead_tuples
---------+----------+-----------+-------------------------+-------------------------
tbl_1 | 1 | 4 | 0 | 0
(1 row)
analyze 收集统计信息后, pg_stat_get_live_tuples ---这个活的记录数,期望的是4 ,才对,因为4条记录,没做任何操作,没删除,没更新,所以活的记录数应该是4个才对;不知道为啥显示是0
版本 pg---10