Re: Add stats_reset to pg_stat_all_tables|indexes and related views

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Sami Imseih <samimseih(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Add stats_reset to pg_stat_all_tables|indexes and related views
Date: 2025-10-08 04:45:48
Message-ID: aOXsfBhxjWmqxJYH@ip-10-97-1-34.eu-west-3.compute.internal
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Wed, Oct 08, 2025 at 12:54:18PM +0900, Michael Paquier wrote:
>
> So at the end, I have added
> a new step that queries pg_stat_get_function_stat_reset_time(), and
> used it in the only permutation that does a reset of the counters.

Makes sense and it still tests null and not null cases for the new field (
so both cases are covered).

> Applied with this tweak, and bumps with the
> mandatory bumps for the catalog version and PGSTAT_FILE_FORMAT_ID.

Thanks!

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2025-10-08 04:59:01 Re: Questionable result from lead(0) IGNORE NULLS
Previous Message Chao Li 2025-10-08 04:36:35 Re: Optimize LISTEN/NOTIFY