Re: Feature improvement for pg_stat_statements

From: Andres Freund <andres(at)anarazel(dot)de>
To: btnakamichin <btnakamichin(at)oss(dot)nttdata(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Feature improvement for pg_stat_statements
Date: 2020-09-21 19:58:39
Message-ID: 20200921195839.qdvu4caovtbv67l3@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2020-09-21 20:02:29 Re: recovering from "found xmin ... from before relfrozenxid ..."
Previous Message Tomas Vondra 2020-09-21 19:56:07 Re: WIP: BRIN multi-range indexes