Re: Add connection active, idle time to pg_stat_activity

From: Sergey Dudoladov <sergey(dot)dudoladov(at)gmail(dot)com>
To: Andrei Zubkov <zubkov(at)moonset(dot)ru>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Aleksander Alekseev <aleksander(at)timescale(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>
Subject: Re: Add connection active, idle time to pg_stat_activity
Date: 2024-11-27 07:28:25
Message-ID: CAA8Fd-rE5Mu1p2w6hi_xVuf2qgzDx24o6-AbfxTSUrS_d1SdDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Attachment Content-Type Size
0005-Add-pg_stat_session.patch text/x-patch 21.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Anthonin Bonnefoy 2024-11-27 07:28:50 Re: Consider pipeline implicit transaction as a transaction block
Previous Message vignesh C 2024-11-27 07:15:15 Re: Improve the error message for logical replication of regular column to generated column.