Re: Feature improvement for pg_stat_statements - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Feature improvement for pg_stat_statements
Date
Msg-id 20200921195839.qdvu4caovtbv67l3@alap3.anarazel.de
Whole thread Raw
In response to Feature improvement for pg_stat_statements  (btnakamichin <btnakamichin@oss.nttdata.com>)
Responses Re: Feature improvement for pg_stat_statements  (btnakamichin <btnakamichin@oss.nttdata.com>)
List pgsql-hackers
Hi,

On 2020-09-18 17:55:12 +0900, btnakamichin wrote:
> I’m thinking of adding adding a function called
> pg_stat_statements_reset_time() that returns the last timestamp when
> executed pg_stat_statements_reset(). pg_stat_statements can reset each SQL
> statement. We can record each sql reset timing timestamp but I don’t feel
> the need. This time, I’m thinking of updating the reset timestamp only when
> all stats were reset.

What exactly do you mean by "can reset each SQL statement"? I don't
really see what alternative you're analyzing?

It does make sense to me to have a function returning the time of the
last reset.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: WIP: BRIN multi-range indexes
Next
From: Robert Haas
Date:
Subject: Re: recovering from "found xmin ... from before relfrozenxid ..."