Re: Add connection active, idle time to pg_stat_activity

Sergey Dudoladov <sergey.dudoladov@gmail.com>

From: Sergey Dudoladov <sergey.dudoladov@gmail.com>

To: Andrei Zubkov <zubkov@moonset.ru>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Aleksander Alekseev <aleksander@timescale.com>, vignesh C <vignesh21@gmail.com>

Date: 2024-11-27T07:28:25Z

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 →

Remove unstable pg_amcheck tests.
- cd3f429d9565 15.0 cited

Attachments

0005-Add-pg_stat_session.patch (text/x-patch) patch 0005

Hello, hackers.

I've attached the fifth version of the patch that incorporates suggestions
from Andrei.
The version  runs successfully on top of 8fcd80258bcf43dab93d877

> Right now it is not clear for me if we can get resource statistics from
> those backends while those are listed in the pg_stat_activity view but
> renaming to something like 'pg_stat_backend' seems reasonable to me.

For now I kept the "pg_stat_session" naming because I don't know how
desirable it is to collect the
resource statistics in this view given that a plenty of other pg_stat_*
views exists for other backends.

Regards,
Sergey.