From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | zlianzhuang(at)163(dot)com |
Subject: | BUG #15801: pg_stat_database update stats_reset only by pg_stat_reset |
Date: | 2019-05-13 07:15:47 |
Message-ID: | 15801-21c7fbff08b6c10c@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15801
Logged by: zhang lian zhuang
Email address: zlianzhuang(at)163(dot)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。
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Gierth | 2019-05-13 07:57:31 | Re: BUG #15800: Order by random in functions |
Previous Message | PG Bug reporting form | 2019-05-13 06:35:18 | BUG #15800: Order by random in functions |