15670430创建于 2020年12月28日历史提交
insert into t1_part values (generate_series(1,51),generate_series(1,51),generate_series(1,51));
CALL sleep_loop_autoanalyze_count(1, 't1_part', 0.1);
 sleep_loop_autoanalyze_count 
------------------------------
 
(1 row)

copy t1_part from '@abs_srcdir@/data/autoanalyze_test_data.txt';
CALL sleep_loop_autoanalyze_count(2, 't1_part', 0.1);
 sleep_loop_autoanalyze_count 
------------------------------
 
(1 row)

update t1_part set a = 3,b = 2 where a < 35 AND a > 0;
CALL sleep_loop_autoanalyze_count(3, 't1_part', 0.1);
 sleep_loop_autoanalyze_count 
------------------------------
 
(1 row)

delete from t1_part where a < 50 AND a > 0;
CALL sleep_loop_autoanalyze_count(4, 't1_part', 0.1);
 sleep_loop_autoanalyze_count 
------------------------------
 
(1 row)

select
	pg_stat_get_analyze_count('t1_part'::regclass) as analyze_count,
	pg_stat_get_autoanalyze_count('t1_part'::regclass) as autoanalyze_count,
	pg_stat_get_vacuum_count('t1_part'::regclass) as vacuum_count,
	pg_stat_get_autovacuum_count('t1_part'::regclass) as autovacuum_count
from dual;
 analyze_count | autoanalyze_count | vacuum_count | autovacuum_count 
---------------+-------------------+--------------+------------------
             4 |                 4 |            0 |                0
(1 row)