Postgres Pro
Downloads
Home   >   mailing lists

Re: Include a timestamp in future versions of pg_stat_statements when when a query entered the cache? - Mailing list pgsql-performance

From Julien Rouhaud
Subject Re: Include a timestamp in future versions of pg_stat_statements when when a query entered the cache?
Date
Msg-id ZXAYc2UV5vdUTADo@jrouhaud
Whole thread Raw
In response to Include a timestamp in future versions of pg_stat_statements when when a query entered the cache?  (Jerry Brenner <jbrenner@guidewire.com>)
List pgsql-performance
Tree view 
Hi,

On Tue, Dec 05, 2023 at 06:28:54AM -0800, Jerry Brenner wrote:
> It would be helpful if a timestamp column was added to pg_stat_statements
> to denote when a query entered the view.  This would make it easier to tell
> how frequently a query is being executed (100,000 times since a specific
> timestamp vs 100,000 times since the execution stats were last reset.)

This was actually done a few weeks ago, and will be available with pg 17.  You
can see the 2 new timestamp counters (one for the whole record, one for the
minmax counters only) documentation at
https://www.postgresql.org/docs/devel/pgstatstatements.html

pgsql-performance by date:

Previous
From: Jerry Brenner
Date:
Subject: Include a timestamp in future versions of pg_stat_statements when when a query entered the cache?
Next
From: Jerry Brenner
Date:
Subject: Question about semantics of $ variables in json explain plans in 13