BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset
От | PG Bug reporting form |
---|---|
Тема | BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset |
Дата | |
Msg-id | 15801-21c7fbff08b6c10c@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15801: pg_stat_database update stats_reset only bypg_stat_reset
Re: BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 15801 Logged by: zhang lian zhuang Email address: zlianzhuang@163.com PostgreSQL version: 11.1 Operating system: linux Description: pg_stat_reset_single_table_counters/pg_stat_reset_single_function_counters only update pg_stat_database column stats_reset. stat_reset shuld update when all the column is reset. sample: drop database if exists lzzhang_db; create database lzzhang_db; \c lzzhang_db create table lzzhang_tab(id int); insert into lzzhang_tab values(1); insert into lzzhang_tab values(1); select tup_fetched, stats_reset from pg_stat_database where datname='lzzhang_db'; select pg_sleep(1); select pg_stat_reset_single_table_counters('lzzhang_tab'::regclass::oid); select tup_fetched, stats_reset from pg_stat_database where datname='lzzhang_db'; result: tup_fetched | stats_reset -------------+------------------------------- 514 | 2019-05-12 03:22:55.702753+08 (1 row) tup_fetched | stats_reset -------------+------------------------------- 710 | 2019-05-12 03:22:56.729336+08 (1 row) tup_fetched is not reset。
В списке pgsql-bugs по дате отправления: