[Patch] Add a reset_computed_values function in pg_stat_statements - Mailing list pgsql-hackers

From Pierre Ducroquet
Subject [Patch] Add a reset_computed_values function in pg_stat_statements
Date
Msg-id 1762890.8ARNpCrDLI@peanuts2
Whole thread Raw
Responses Re: [Patch] Add a reset_computed_values function in pg_stat_statements
List pgsql-hackers
Hello

pg_stat_statements is a great tool to track performance issue in live 
databases, especially when adding interfaces like PoWA on top of it.
But so far, tools like PoWA can not track the min_time, max_time, mean_time 
and sum_var_time of queries : these statistics are cumulated over time, 
fetching points in time would be of little to no use, especially when looking 
at the impact of a DDL change.
This patch thus introduces a simple pg_stat_statements_reset_computed_values 
function that reset the computed statistics, leaving all other information 
alive, thus allowing the aforementioned scenario.

Regards

 Pierre Ducroquet
Attachment

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Write visibility map during CLUSTER/VACUUM FULL
Next
From: Erik Rijkers
Date:
Subject: Re: row filtering for logical replication