Add test for pg_stat_reset_single_table_counters() on index
Michael Paquier <michael@paquier.xyz>
Add test for pg_stat_reset_single_table_counters() on index stats.sql is already doing some tests coverage on index statistics, by retrieving for example idx_scan and friends in pg_stat_all_tables. pg_stat_reset_single_table_counters() is supported for an index for a long time, but the case was never covered. This commit closes the gap, by using this reset function on an index, cross-checking the contents of pg_stat_all_indexes. Author: Bertrand Drouvot <bertranddrouvot.pg@gmail.com> Discussion: https://postgr.es/m/aN8l182jKxEq1h9f@paquier.xyz
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/stats.out | modified | +21 −0 |
| src/test/regress/sql/stats.sql | modified | +9 −0 |
Discussion
- Add stats_reset to pg_stat_all_tables|indexes and related views 13 messages · 2025-10-02 → 2025-10-08