Re: Add connection active, idle time to pg_stat_activity

From: Sergey Dudoladov <sergey(dot)dudoladov(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Andrei Zubkov <zubkov(at)moonset(dot)ru>, 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-02-01 17:41:55
Message-ID: CAA8Fd-rj3G2jc3PGNN2xG4K8+H1y1rQtJCMr5f9+BW5d_3q+9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

@Andrei Zubkov
I've modify the patch to address most of your comments.

> I have a thought about other possible improvements fitting to this patch.
> I think pg_stat_session view is able to add one more dimension of
monitoring - a dimension of sessions

I would like to remind here about the initial scope of this patch. The main
goal of it was to ease tracking "idle in transactions" connections, a
feature that would really help in my work. The "pg_stat_session" came into
play only because the "pg_stat_activity" was seen as an unsuitable place
for the relevant counters. With that I still would like to maintaint the
focus on committing the "idle in transactions" part of pg_stat_session
first.

Regards,
Sergey

Attachment Content-Type Size
0003-Add-pg_stat_session.patch text/x-patch 19.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message vignesh C 2024-02-01 17:42:02 Re: Asynchronous execution support for Custom Scan
Previous Message Tom Lane 2024-02-01 17:32:00 Re: 003_extrafiles.pl test fails on Windows with the newer Perl versions