Support reset of Shared objects statistics in "pg_stat_reset" function
Sadhuprasad Patro <b.sadhu@gmail.com>
From: Sadhuprasad Patro <b.sadhu@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2021-08-06T08:26:21Z
Lists: pgsql-hackers
Attachments
- 0001-pg_stat_reset-and-pg_stat_reset_single_table_counter.patch (application/octet-stream) patch 0001
Hi, The call to “pg_stat_reset“ does reset all the statistics data for tables belonging to the current database but does not take care of shared tables e.g pg_attribute. Similarly to reset the statistics at table level, the call to “pg_stat_reset_single_table_counters“ does not take care of shared tables. When we reset all the statistics using the call “pg_stat_reset”, the postgres process internally makes calls to “ pgstat_recv_resetcounter“, which resets the statistics of all the tables of the current database. But not resetting the statistics of shared objects using database ID as 'InvalidOid'. The same fix is made in the internal function “pgstat_recv_resetsinglecounter“ to reset the statistics for the shared table for the call "pg_stat_reset_single_table_counters". -- thank u SADHU PRASAD EnterpriseDB: http://www.enterprisedb.com
Commits
-
Enhance pg_stat_reset_single_table_counters function.
- e04267844a9b 15.0 landed