Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements
Andrei Zubkov <zubkov@moonset.ru>
From: Andrei Zubkov <zubkov@moonset.ru>
To: pgsql-hackers@lists.postgresql.org
Date: 2021-10-07T12:31:51Z
Lists: pgsql-hackers
Commits
Same data as JSON:
GET /api/v1/messages/:b64id/commits
the thread's linked commits as JSON, with link sources.
API reference →
-
Improve quoting in some error messages
- 07e5e6674233 14.0 cited
There is an issue with this patch. It's main purpose is the ability to calculate values of pg_stat_statements view for a time period between two samples without resetting pg_stat_statements being absolutely sure that the statement was not evicted. Such approach solves the problem for metrics with except of min and max time values. It seems that partial reset is needed here resetting min/max values during a sample. But overall min/max values will be lost in this case. Does addition of resettable min/max metrics to the pg_stat_statemets view seems reasonable here? -- Andrei Zubkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company