Hi,
On 25.02.2021 02:03, Andres Freund wrote:
pg_stat_aio_backends.
This stat is based on COUNTERs, which is great, but the issue here is that
its lifespan is limited by the lifespan of the backend processes - once the
backend exits the stat will no longer be available - which could be
inappropriate in workloads with short-lived backends.
There's a todo somewhere to roll over the per-connection stats into a
global stats piece on disconnect. In addition I was thinking of adding a
view that sums up the value of "already disconnected backends" and the
currently connected ones. Would that mostly address your concerns?
Yes, approach with separated stats for live and disconnected backends
looks good and solves problem with "stats loss".
Or it can be done like a stats for shared objects in pg_stat_databases,
where there is a special NULL database is used.
Regards, Alexey
