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