pg_stat_statements: Track time at which all statistics were last reset.
Fujii Masao <fujii@postgresql.org>
pg_stat_statements: Track time at which all statistics were last reset. This commit adds "stats_reset" column into the pg_stat_statements_info view. This column indicates the time at which all statistics in the pg_stat_statements view were last reset. Per discussion, this commit also changes pg_stat_statements_info code so that "dealloc" column is reset at the same time as "stats_reset" is reset, i.e., whenever all pg_stat_statements entries are removed, for the sake of consistency. Previously "dealloc" was reset only when pg_stat_statements_reset(0, 0, 0) is called and was not reset when pg_stat_statements_reset() with non-zero value argument discards all entries. This was confusing. Author: Naoki Nakamichi, Yuki Seino Reviewed-by: Yuki Seino, Kyotaro Horiguchi, Li Japin, Fujii Masao Discussion: https://postgr.es/m/c102cf3180d0ee73c1c5a0f7f8558322@oss.nttdata.com
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pg_stat_statements/pg_stat_statements--1.8--1.9.sql | modified | +3 −2 |
| contrib/pg_stat_statements/pg_stat_statements.c | modified | +35 −11 |
| doc/src/sgml/pgstatstatements.sgml | modified | +15 −3 |
Documentation touched
Discussion
- Feature improvement for pg_stat_statements 22 messages · 2020-09-18 → 2020-12-18